Sign in to join the conversation:
Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down.
If cell is blank, nothing needs to happen.
If cell is "delete" or "archive", I would like the row to become hidden.
Any help would be awesome.
Hi Kelly,
Unfortunately, there isn't a way to hide rows, but depending on your use case you could use a report that doesn't show them.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant / Get Done
Hiding rows based on a cell value would be very useful. I see this thread goes back a loooong time. Does the Smartsheet group even try to provide requested changes?
Hi Dave,
I agree it's a great idea, and they do, but as you can imagine there are a lot of requests.
Please submit an Enhancement Request when you have a moment to have your vote addedA New Way to Submit Your Feature RequestsTo make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests
Have a fantastic weekend!
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
Hello Community, I need to create a report that shows capacity by month. My sheet tracks resource allocation on projects with resource start and end dates. (We can't afford the Resource Management module so we're doing it in Core SS). I've been asked to do a "heat map" of sorts where each column is a month. For each row…