Report Filtering on a Cell
Hi all,
Is it an option to Filter out items based on 1 cell in a sheet? We have a project plan and there is a cell that designates the entire project complete that is at the top. Is there a way to exclude data from sheets that have that cell as complete or do you have to filter based on an entire column?
Thanks for any help you can provide.
Amanda
Answers
-
You would have to filter based on an entire column. You could create a hidden helper column and use a cell reference to replicate that into each row on the sheet.
-
Thanks Paul, that was going to be my Plan B! I appreciate your help
-
Happy to help. 👍️
Additional notes on that... I don't think you can use a locked in cell reference as a column formula, but you can use a cell reference in a Summary Field and then reference that Summary Field as a column formula. This should help avoid autofill issues if new rows are being added regularly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!