IF Statement - Checkboxes

Hi there,


I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field is left blank and the Status is "In Progress" the checkbox is marked off. I want to make it so if the End Date is blank there is no check mark. What is the best way to go about this?

Formula: =IF(AND([End Date]@row <= TODAY(30), Status@row = "In Progress"), 1, 0)


Thanks!

Mahshad

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!