How do I alert someone if the "Completion Date" is blank after 7 days from the "Submission Date"?

Options

I have a column for date submitted and there is a column for Completion Date. I want it to alert someone if there is no completion date seven days after the submission date. I think it is conditional formatting, but I cant figure out how to write it.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!