Help with a formula that I need to return the result of Green for 2 reasons
Good day: I have my formula mostly figured out (see below). I want the result of green if my % Completed is 100 or if the End date is >15 days from today.
How can I accomplish this?
=IF([% Completed]@row = 1, "Green", IF(ISBLANK([End Date]@row), "Blue", IF([End Date]@row < TODAY(), "Red", IF(([End Date]@row  TODAY()) <= 14, "Yellow"))))
Tags:
Answers

You can use the OR( ) function. The structure is IF( OR( criterion_1 , criterion_2 ), "Green", "Something_Else" ).
criterion_1 is
[% Completed]@row = 1
criterion_2 is
NETDAYS(TODAY(), [End Date]@row) > 15
Documentation on Smartsheet functions can be found here...
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!