"Record a Date" Automation to a Cell in a Hidden Column

delberto

I have lots of sheets for a reviewing process - each item to review has a new sheet from a template. Each sheet has about 30 rows and a summary sheet.

I have an automation that does the following:

1. When "status" cell changes, request an approval. (This is calculated in a summary sheet and written to a cell.)
2. Approval comes to me and I click to approve.
3. It then emails various people and…
4. … should record a date….

All works ok but step 4 seems unreliable.

The cell that it writes the date to is usually hidden - for a cleaner sheet when viewed - the crucial data is pulled into a Sheet Summary.

Question is - might it be a problem writing a date to a cell in a hidden column?
Thanks.

Paul Newcome

I set up record a date automations populating hidden columns A LOT and have never had any trouble with them. Are you able to provide some screenshots of the automation(s)?