Formula Help

henryflorez1914

henryflorez1914 ✭✭

09/08/23 in Formulas and Functions

I need a formula that says, if end date is one day away, and %complete is less than 50% done, then change the Health column cell

to red. If %complete is 100%, then change Health column cell to blue, otherwise keep health column cell green. Can someone help?

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Schedule health formula to display blank symbol
Hello! I am curious how to edit the below formula, to show blank instead of green/yellow/red symbol if status/end date is blank: =IFERROR(IF(Status@row = "Complete", "Green", IF(Status@row = "N/A", "Green", IF([End Date]@row = TODAY(), "Yellow", IF([End Date]@row < TODAY(), "Red", "Green")))), " ")
Count HAS Function Between Dates
I have worked to find a solution out there but not getting one that works. I am collecting data from a sheet to be used in charts on a dashboard (so referencing another sheet). The result will need to be generated from two columns Date - date the project closed Fund - The fund/funds used to pay for the project (multiselect…
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…