Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Set a dropdown value for all selected cells
For nested items especially, it would be nice to select multiple rows' dropdown cells, right click, and set a dropdown value across all those that are selected.
So, 5 nested rows whose parent's dropdown for "status" is set to "complete". I'd like to be able to select cells from that same column for the nested rows and apply the same status.
Comments
-
If you are always doing the same manual process, you could look at formulas to do it for you automatically.
Craig
-
Hello,
Β
Craig is right that a formula could help automate this process for you. With your example, if you want allΒ child rows in your dropdown column to be the same thing you setΒ their parent to, you could fill that column withΒ a formula like this:
Β
=PARENT()
Β
This will make a childΒ row equal toΒ it's parent for any column you choose to put this in. Keep in mind however that if the child row is ever manually changed, the formula will go away and would have to be put back in if needed.
Β
Robert
