Nested If with Multiple Conditions Automation for Project Management

Hi SS Community! 

 

Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. 

Currently, I have this: 

=IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started")

 

I just need to automate

If the start date is within 2 weeks and the status is not complete or in progress, then mark it as on deck. 

Otherwise, default to not started. 

Thanks for the advice in advance! :) 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!