Symbol for Status

Vinton Douglas

Hello,

I am trying to create a formula using symbols (bubbles) to indicate "red" after a due date has reached, "yellow" when it reaches 90 days before the due date, "green" when it is more than 90 days before the due date. I used the following formula but the formula remains in the column instead of it changing to the symbol (bubble). The formula I used is:  =IF([Due Date] >= Today + 90, "Green", IF([Due Date] >= Today, "Yellow", "Red"))

Any help would be welcome.

Regards,

Vinton

Bassam Khalil

Ok @Vinton Douglas

I will check it for you now

Vinton Douglas

Bassam, thanks much. The formula you created works extremely well. You are superb and much appreciated

Bassam Khalil

Hi @Vinton Douglas

Hope you are fine, please try the following formula an convert it to column format formula:

=IFERROR(IF(ISBLANK([Due Date]@row), "", IF([Due Date]@row >= TODAY(), "Red", IF([Due Date]@row >= TODAY(-90), "Yellow", IF([Due Date]@row < TODAY(-90), "Green")))), "")

the following screenshot shows the result:

Vinton Douglas

Hi Bassam,

Thanks for responding and much appreciated. I believe this might be a problem with me. I am unable to view the bubbles (Red, yellow and green dots) despite inserting the formula you created. I believe that I might not be inserting the formula on the correct platform. I am new to Smartsheet and would be grateful if you could provide further assistance so that the appropriate bubble appear based on current date. Do I insert the formula under sheet summary? or do I click the Health column I created and insert the formula. I tried both but the bubbles are still not appearing.

Regards,

Vinton

Andrée Starå

Hi @Vinton Douglas

I hope you're well and safe!

Can you maybe share some screenshots of what you're seeing? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

@Vinton Douglas

if you can share me as an admin on a copy of your sheet (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Email: [email protected]

Vinton Douglas

Thanks much Bassam, I shared the sheet with you. Did you receive it?

Bassam Khalil

Ok @Vinton Douglas

I will check it for you now

Vinton Douglas

Bassam, thanks much. The formula you created works extremely well. You are superb and much appreciated

Bassam Khalil

@Vinton Douglas

Excellent, i will be happy to help you any time.