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

Joan

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.

Andrée Starå

Hi Joan

I hope you're well and safe!

Do you want to send them an Alert or change the color of the cell/row?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Joan

I want to send an alert to someone if there is no completion date 7 days after the submission date.

Sharon W.

Is there an update on this question?

Lincoln Brown

Hi Did this ever get resolved?

I too am looking for a way of getting notified is a cell hasn't been filled in within a timescale of another cell being completed.

Was expecting there to be a template for this scenario.