Is there a way to record date to an individual cell and not an entire column?

CK17

Hello,

I am attempting to use the Record Date automation to force my sheets to refresh automatically every day, early in the morning. This is to ensure that equations I have using Today(), refresh with today's date. Otherwise on my report pages and dashboards, tasks show an incorrect deadline status based on the old Today() function.

I've found that if I use a hidden column and 'record date' that I am able to refresh the sheets daily. The only problem is that I also use a formula for 'complete date' when a 'complete' box in the column prior is selected. If any changes are made to the entire row after this box is selected, it updates to that day (another Today() equation).

Because of this I am wondering if I can have the 'Record a date' function ONLY populate a single cell (first row, last column for example) that won't trigger every row to update?

Otherwise I'll have to make the complete date manual entry and keep record date automation to still populate every spreadsheet as this functionality has more utility than automatically updating complete date.

Thank you in advance.

Genevieve P.

Hi @CK17

Yes, this is possible!

You'll want to have a row that you know will always stay in the sheet which contains a Unique Value... for example a header row with the project name. Or, you could create a Helper Row at the top that you lock to ensure no one makes changes.

Then you can use a Condition Block in your workflow to say only run if the Cell with your unique value contains the "unique value", like so:

See: Condition Blocks: Filter What Your Automated Workflows Send

Cheers,

Genevieve

Genevieve P.

Hi @CK17

Yes, this is possible!

You'll want to have a row that you know will always stay in the sheet which contains a Unique Value... for example a header row with the project name. Or, you could create a Helper Row at the top that you lock to ensure no one makes changes.

Then you can use a Condition Block in your workflow to say only run if the Cell with your unique value contains the "unique value", like so:

See: Condition Blocks: Filter What Your Automated Workflows Send

Cheers,

Genevieve

CK17

That appears to do the trick, thank you again @Genevieve P. !