Need help with virtually switching rows and columns
In my smartsheet I have rows of activities that are either complete or not for each column that corresponds to a room. My struggle is that when working with the data in the field I want to be looking at a specific room and updating itโs activities. When I view in Smartsheet I want to see the progress for each room going down the sheet (rows). I am having trouble getting my head around how to essentially swap rows and columns for purposes of entering data. Anybody tackled anything like this before? I have looked at using slices for each column but canโt get ti to conform into something workable.
User | Count |
---|---|
17 | |
12 | |
7 | |
4 | |
3 |