Change in Status column effects Assigned to Column

ddonovan44616

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.

Andrée Starå

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