How to change status based on start/end dates/if completed was checked or not.

Hi there,

I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figuring out how to create a formula where if start date is in the past and end date is in the future, having it automatically change the status to in progress, same for if the end date is past and the check box is not checked, having it automatically changing the status to delayed, etc. Can you please help me with this?

Thanks in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!