Sign in to join the conversation:
I cannot figure out why this formula does not work. HELP! Thanks.
Suggestions:
=IF([Complete]1 = 1, "B"),
IF([Finish]1< TODAY, "R"),
IF([Finish]1 >= TODAY(+45), "Y"),
IF([Finish]1 <= TODAY(+90), "G", " ")))
Hi,
Are you trying to use the RYGB Symbols? Do you get an error message?
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Try something like this.
=IF(Complete@row = 1; "Blue"; IF(ISBLANK(Finish@row); ""; IF(Finish@row < TODAY(); "Red"; IF(Finish@row >= TODAY(45); "Yellow"; IF(Finish@row <= TODAY(90); "Green"; "")))))
The same version but with the below changes for your and others convenience.
=IF(Complete@row = 1, "Blue", IF(ISBLANK(Finish@row), "", IF(Finish@row < TODAY(), "Red", IF(Finish@row >= TODAY(45), "Yellow", IF(Finish@row <= TODAY(90), "Green", "")))))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
I was not able to get this to work.
Ok. Do you get an error message?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Hi all, I’m looking to get more up to speed with Smartsheet timelines, especially features like Gantt charts, dependencies, milestones, and overall timeline best practices. I’ve already built out one sheet and understand the basics, but I’d love to learn more about the tips, tricks, and best practices that more experienced…
We changed from an enterprise licence to specific accounts. I have a licence and setup a workspace for our global team to edit and collaborate across various sheets. I granted editor can share rights to all non licensed members and shared the publish link with them. This has worked well and allowed them to edit cells,…
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…
