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.