"Record a Date" Automation to a Cell in a Hidden Column
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:
- When "status" cell changes, request an approval. (This is calculated in a summary sheet and written to a cell.)
- Approval comes to me and I click to approve.
- It then emails various people and…
- … 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.
Best Answer
-
Excellent!
Happy to help!
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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)?
-
Hi Paul, thanks for responding. I've attached a couple screenshots.
I didn't think that hidden columns should affect it but as I mentioned, it does sometimes work - so something odd is going on - or more likely I'm missing something. -
Hi,
I hope you're well and safe!
Yes, that's strange. It should work just fine, and I double-checked and tested it.One thing to try. Try copying the workflow and deactivating the original to see if it's just a glitch.
If that doesn't make any difference, and If you haven't already, I recommend submitting a support ticket through the new Smartsheet Support Portal.
Feel free to report back what the issue was.
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå . I'll try that - and then monitor it for a while, give it a few chances to fail.
Thanks for the help! -
Excellent!
Happy to help!
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives