edited 04/14/23 in Formulas and Functions


I am trying to create an IF(AND) statement, but I cannot figure it out.  Any help would be greatly appreciated.

I am trying to write a formula that will check the "at risk" if the the "done" column is not checked and the due date is 7 days before today.





  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Try this... The trigger for checkboxes is 1 = checked, 0 = unchecked. When you say 7 days before today, I am assuming you are meaning 7 days ago. If not, then remove the minus from the Today(-7). Hope this helps. When formulating and statements you have to open them (, then list all the criteria (comma separated) and then close the and statement ), before writing out the rest of the IF statement. 

    =IF(AND(Done@row = 0, [Due Date]@row < Today(-7)), 1, 0) 

  • Ken Pavell
    Ken Pavell ✭✭✭

    I am trying to get the following formula to work but all options I have tried return Unparseable error. =IF(AND(Status@row = 2, CustYr@row = "Year1"), 0.1, (IF(AND(Status@row = 2, CustYr@row = "Year2+"), 0.08, 0.07)), 0.07)

    The formula is checking if Status = 2 and if CustYr = "Year1" is true return 0.10, if it is false then I want to execute the second IF/And statement of Status = 2 and CustYr = "Year2+" is true return 0.08 and if false 0.07.

  • Eric Law
    Eric Law ✭✭✭✭✭✭

    Hello @Ken Pavell

    I've corrected your formula, see if it works

    =IF(AND(Status@row = 2, CustYr@row = "Year1"), 0.1, IF(AND(Status@row = 2, CustYr@row = "Year2+"), 0.08, 0.07)))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!