Options where more than one 'Modified By' column is required
Hello
I have a sheet where I need to capture the name of the person who 'checks a box'.
I have used the 'Modified By' system column to do this.
Unfortunately, I have 3 check boxes in total.
Any ideas on a workaround, other than a copy row to two sheets with an INDEX MATCH pulling in the name on the 'master' sheet? Or a manual dropdown for the User to enter their details?
Many thanks in advance!
Answers
-
The only options would be the two options you are wanting to avoid. Wither using the copy row automation to grab the static data and an INDEX/MATCH to pull it or a manual selection of their name instead of the checkbox.
-
Thankyou Paul
-
Hi @1845sarah
I hope you're well and safe!
To add to Paul's excellent advice/answer.
What do you mean by "copy row to two sheets"?
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 support the Community 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!
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.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!