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
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
