Automation - Record a Date

AAL

I have a question regarding how to use the automation to set up the following:

when the Notes column is changed, it will record the date. However, it keeps saying I don't have the Date column and actually I have a Start Date column in my Sheet, so I don't know what's wrong with this. Would you please advise me on how to fix this? Thanks!

Hollie Green

Is your start date set up as a "Date Column" or are you just typing dates into a text column?

AAL

it is a Date column.

Genevieve P.

Hi @AAL

Are you using a Project Sheet with Dependencies enabled? If so, those columns cannot be updated via formulas or workflows, you would need to manually select dates. If you remove dependencies then you can select these columns in workflows 🙂

Cheers,

Genevieve

AAL

Yes, I have to use dependencies in order to get the duration days. So if I want to have a duration (start date and end date) and I want to set the workflow automation such as Notes column change, please record a date, what options do I have? Thanks!

Genevieve P.

Hi @AAL

In this instance, you'll need to add a new column into the sheet, a new Date column. (Right click on any column name and select this from the dropdown menu). I would perhaps title it something like "Updated Notes". Then you'll be able to select this newly created date column in your workflow! 🙂

Cheers,

Genevieve

AAL

Thank you, Genevieve.