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 |
---|---|
43 | |
28 | |
24 | |
21 | |
13 |