Cells need not have every value manually entered. Users can also use formulas to determine cell values, even when formulas output emojis. Combining formulas with emojis is a fun way to use logic to determine which emojis values to assign to a cell, possibly referencing other cells, or even have worksheets change emojis options based on changes to data in other worksheets.
How to input formulas
Like other cells, you can input a formula selecting the desired cell, clicking on the function bar, and typing in the desired formula.
Note: Currently, Emojis must be pasted into formulas directly. For instance, =IF(A1=TRUE, "👍","👎").
For example, in our team's project tracker, we can indicate a project's status with emojis and use formulas to determine that status. In the animation below, we go into our status column, select a cell, and add in our formula.
The formula we paste in checks if today's date is after the scheduled project date and if the project has been completed yet. Projects that are past their deadline and are not completed get a👎 (thumbs down), projects that are not completed and not past their deadline get 🤷 (shrug), and completed projects get a 👍 (thumbs up).
To see other data types that can use formulas to assign values, check out our advanced formatting articles.