IF Date formula

Kimberly Slavsky

Hello-

I am trying to write a formula for an approval process that if the first approver has approved and if the second approver has not responded in 7 days from the first approver date, there is a checkbox that gets marked. I am just not sure how to write it. Does that make sense?

Paul Newcome

You would use an IF/AND combo along the lines of:

=IF(AND([First Approval Date]@row< TODAY(-7), [Second Approval Date]@row = ""), 1)

Paul Newcome

Are you recording the date when the first approver approves?

Kimberly Slavsky

Yes, the date is recorded for each approval that is received.

Paul Newcome

You would use an IF/AND combo along the lines of:

=IF(AND([First Approval Date]@row< TODAY(-7), [Second Approval Date]@row = ""), 1)

Kimberly Slavsky

This is perfect thank you!!

Paul Newcome

Happy to help. 👍️