- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โNov 23, 2023 11:02 AM - edited โNov 23, 2023 11:04 AM
Hello,
I am a commercial insurance agent and have create a pipeline report. I have a working formula that tells me how many days I have left before a policy needs to be renewed -
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โNov 23, 2023 05:42 PM
Thanks to both of you. I am on the free plan at this time and don't have colors or emojis. The formula worked but the cell showed the name of the emoji. I was on the paid plan for a while but $20 is a bit much for only one sheet that I use this for.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โNov 23, 2023 11:09 AM
Not in the cell itself, but you could use conditional record coloring for this, based on your formula field.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โNov 23, 2023 05:29 PM - edited โNov 23, 2023 05:31 PM
Or use emojis.
IF({Due Date},
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โNov 23, 2023 05:42 PM
Thanks to both of you. I am on the free plan at this time and don't have colors or emojis. The formula worked but the cell showed the name of the emoji. I was on the paid plan for a while but $20 is a bit much for only one sheet that I use this for.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โNov 23, 2023 05:48 PM
Emojis would be available on the free plan.
It is a copy-paste issue.
Press Windows+. key and try inputting it again yourself.

