Automation based on Created Date field

Lara Lehnerz

I am trying to create an automation based on the Created date, however the system generated 'Created Date' field is not an option in the 'Alert Someone' automation template. How can I accomplish this?

Scenario: I need to alert the submitter when project is older than 2 weeks from the created date that the project is still in queue to be assigned.

Paul Newcome

You would need to insert a Date type column and then use

=DATEONLY([Created Date Column Name]@row)

You can then reference this new date column in your automation setup.

Paul Newcome

You would need to insert a Date type column and then use

=DATEONLY([Created Date Column Name]@row)

You can then reference this new date column in your automation setup.

Lara Lehnerz

Thank you Paul.

Paul Newcome

Happy to help. 👍️

Lara Lehnerz

Hi Paul,

What am I doing wrong?

Paul Newcome

@Lara Lehnerz Replace the 1 with row.

=DATEONLY([Created_Date]@row)

Lara Lehnerz

Thanks Paul, I figured it out.