Send email Alert to those who haven' submitted their status for the day



I've been trying to figure out how to create an automation send Alert email to resources who haven't submit their status for the day. Can you help me or suggest on how am I able to achieve this?

Thank you.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I would suggest a helper Date type column with this formula...

    =IF([Creation Date]@row = MAX(COLLECT([Creation Date]:[Creation Date], [Name Column]:[Name Column], [Name Column]@row)), DATEONLY([Creation Date]@row)

    This will pull the date for the most recent submission for that person into the helper column. You can then adjust your alert to trigger only on rows where that column is not blank and is is the past.