I have the following columns: [Building and Room], [Room Type]. In any given row in [Room Type] - there will be a value of "Standard" or "Non-Standard".
Is there a way to look at values in [Room Type] and then autofill the rest of the cells in that column with that same value?
The tricky thing is that "Standard" and "Non-Standard" pertain to a certain [Building and Room] location. For example Room 123 = "Standard", but Room 234 = "Non-Standard".
I won't know if location (Room 123) is a Standard or Non-Standard room until after an inventory of that room is complete.
The other tricky part is that I'm also including columns that calculate price rates based on that "Standard" or "Non-Standard" designator.
I've created a smartsheet form whereby I designate that a room is "Standard" or "Non-Standard" - but that form is not completed until after the inventory is completed.
I suppose that the "Standard" or "Non-Standard" designator could be cut and paste into the correct row once it's been determined that the space is standard vs. non-standard, and then my calculations would work - but I was hoping that there was a more automated way.
