Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF statement with two criteria; not functioning

edited 12/09/19 in Archived 2016 Posts

Hey all,


Trying to get a “No” to appear if the checkboxes in each column haven’t been checked off by their due date. Currently, it says no regardless of the date and it only seems to switch to "Yes" if the Client Launched column is checked off.


The two criteria are that the box is not checked off and the Launch Date is greater (or less than depending on the step) the function TODAY() + X days


This is the current formula, broken down


=IF(AND([Client Launched]1 = 0, [Launch Date]1 > TODAY()), "No",


 IF(AND([Step 7]1 = 0, [Launch Date]1 < TODAY() + 23), "No",


IF(AND([Step 6]1 = 0, [Launch Date]1 < TODAY() + 27), "No",


IF(AND([Step 5]1 = 0, [Launch Date]1 < TODAY() + 30), "No",


 IF(AND([Step 4]1 = 0, [Launch Date]1 < TODAY() + 51), "No",


 IF(AND([Step 3]1 = 0, [Launch Date]1 < TODAY() + 51), "No",


 IF(AND([Step 2]1 = 0, [Launch Date]1 < TODAY() + 60), "No",



 IF(AND([Signed Contract]1 = 0, [Launch Date]1 < TODAY() + 60), "No", "Yes"))))))))


on track..PNG



This discussion has been closed.