Change in Status column effects Assigned to Column
I have a series of approvals that are being managed through smartsheets. There are many more status conditions and only a few people on the team. I would like to have my Status drop down options correlate to the Assigned To column. Is this possible? I feel like it could be done, but I haven't been able to figure it out.
Comments
-
Hi,
You could add columns for the different scenarios relating to "assigned to" and maybe have a formula that puts that result in the main status column.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
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.