How to Assign People from another Contact Column
I want to assign people in a column to be the same as the contacts assigned in a previous column, unless the user overwrites the new assignment. I.e. if the Stage = "Step 2", the Step 2 Owner will be the same as the Step 1 Owner - unless overwitten to be something else.
So far I've found that the "Assign People" automation workflow allows me to assign the "Step 2 Owner" Column, but doesn't let me pull the value from the "Step 1 Owner" column.
I can use a formula to auto-populate the Step 2 Owner, but the formula doesn't allow me to manually populate a contact into that column anymore.
Formula to populate Step 2 Owner:
=IF(Stage@row = "Step 2", [Step 1 Owner]@row, "")
Screenshot of my current sheet using hte above formula:
Answers
-
So you can create a column level formula, then convert it back to a cell level formula. Then the formula will still exist, but it can be overwritten.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
Interesting, when I try that it works for the first new value, but if I overwrite that new entry, and then create a new line item/row, the formula doesn't work/auto populate into that row.
-
Potentially you could add some "Overwrite" Columns but then have a final "Approver Columns" based on any overwrites
COLUMNS
Step 1 Approver: Manual Entry
Step 2 Overwrite: Manual Entry
Step 3 Overwrite: Manual Entry
Step 2 Approver:
=IF([Step 2 Overwrite]@row = "", [Step 1 Approver]@row,[Step 2 Overwrite]@row)
Step 3 Approver:
=IF([Step 3 Overwrite]@row = "", [Step 2 Approver]@row,[Step 3 Overwrite]@row)
Can repeat for as many steps as you need.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 214 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 457 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!