Date function counting

Cole Frank

I want to have the system count the number of days from when an item has been approved, and if it has been longer than 7 days without a PO being sent to the customer I want it to send an alert to a person

Paul Newcome

You can set up a flag type column. The formula to flag rows where there is no sent date but the approval date is more than 7 days in the past would be:

=IF(AND([PO Sent Date]@row = "", [LN Approval Date]@row< TODAY(-7)), 1)

Then you would set up your automation to rn based on when this column gets flagged.

Paul Newcome

You can set up a flag type column. The formula to flag rows where there is no sent date but the approval date is more than 7 days in the past would be:

=IF(AND([PO Sent Date]@row = "", [LN Approval Date]@row< TODAY(-7)), 1)

Then you would set up your automation to rn based on when this column gets flagged.

Cole Frank

Thank you so much

Paul Newcome

Happy to help. 👍️