Is it possible to auto populate the date in a child row based on the parent row?
I'm using an agenda template with form submission and am hoping there's a way to automate the date once a topic row (child) has been moved under a specific meeting (parent). Any assistance would be great.
Answers
-
I hope you're well and safe!
Yes! You could use the PARENT function to reference a specific parent cell, but you might have to add a so-called helper column.
Something like this.
=PARENT(Column@row)
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!