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
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…