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've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
