RYG Formula

Tony Barthelemy
Tony Barthelemy ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good Day All:

I am trying to add to my formula so that if the Due Date (Actual) is Blank/Empty, the RYG is Blank/Empty. My existing formula:

=IF([Due Date (Actual)]3 > [Due Date (Planned)]3, "Red", IF([Due Date (Actual)]3 < [Due Date (Planned)]3, "Green", IF([Due Date (Actual)]3 = [Due Date (Planned)]3, "Blue")))

Thanks

 

Tags:
«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!