same rows in different sheets - can i make changes to a cell in one sheet and it gets updtd in other
I am not sure if this is possible within Smartsheet, but still keeping my question across
I have a master sheet with a workflow. here a row is copied (not moved) to another sheet if it has the Name of the Responsible person. I am using this sheet for tasks. This workflow is running all fine.
Now what i want is that when this person marks the status as complete in his sheet, the same should appear in the Master sheet as well. The rows are identical and the column names are same in both sheets.
is this possible. if not in this way, i am open to any other options as well.