create past due date workflow

If I understand correctly, @Yashwant Singh, you don't need the Current Date and Date Count columns.

Simply create a new workflow in the Automation pane, title your workflow 'Overdue Task notification' or similar. Choose the 'When a date is reached' trigger and select the Completion Date column as the Date field. Run once 1 day after; you can even fine-tune the delivery time.

Beyond crossing the Completion Date, you can add conditions such as:

• Send the notification only if a Status column is NOT marked complete

You can notify someone in a Contact List cell on that row OR someone else that is shared to the sheet, such as a manager.

Clicking on the ? mark in the Automation pane will take you to helpful tutorials/videos.

I hope this helps.

Hello Yashwant,

You may want to use "When a date is reached" trigger to send an Alert daily.

Within the workflow builder, with the date trigger chosen, you can select "Run Once", and then select Custom. Here it allows you to set a recurrence for the Alert. please see my below screenshot:

See more on this here: https://help.smartsheet.com/learning-track/smartsheet-intermediate/alerts-reminders

Please reach out if you have any questions

Kindest Regards

Sean