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
I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved. =IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer :…
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…
