Help with a formula that I need to return the result of Green for 2 reasons
Options
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!