Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish:
Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a formula or automation.
What is the best way to accomplish this?
Best Answer
-
Addd three columns: "Completed" (Checkbox), "User Who Checked" (Text/Number), and a "Helper Column" (Dropdown with user names or emails).
Create an automation workflow that triggers when "Completed" is checked and updates the "Helper Column" with{{Modified by}}
. Then, in the "User Who Checked" column, use the formula=[Helper Column]@row
to display the value from the "Helper Column". This should then automatically populate the user who checked the box.
Answers
-
Addd three columns: "Completed" (Checkbox), "User Who Checked" (Text/Number), and a "Helper Column" (Dropdown with user names or emails).
Create an automation workflow that triggers when "Completed" is checked and updates the "Helper Column" with{{Modified by}}
. Then, in the "User Who Checked" column, use the formula=[Helper Column]@row
to display the value from the "Helper Column". This should then automatically populate the user who checked the box. -
Is there a way to do this without manually populating the helper column with a drop down list of names/e-mails?
-
Thanks @Spoonhead
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!