=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green"))))
Very new at this, but I can't see the problem...
Try:
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today(), "Red", IF([Due Date]8 = Today(), "Yellow", IF([Due Date]8 > Today(), "Green"))))
edit: I'd also change to @row cell references. It'll make easier to copy.
=IF(Status@row = "Complete", "Blue", IF([Due Date]@row< Today(), "Red", IF([Due Date]@row= Today(), "Yellow", IF([Due Date]@row> Today(), "Green"))))
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
