Only Show Row if Data is in Specific Columns in a Report
Hello,
We have project names, resources, and project managers all listed on the same row with the hours worked on particular days. I'd like to build a report, or a sheet that only shows rows if hours are listed past a certain point, meaning only show rows that have hours listed in the date columns. This will eliminate a lot of unneeded data. Could I use a helper column or a formula to accomplish this?
Best Answer
-
I think there are a couple of ways you could accomplish this. In the sheet, you could create a helper checkbox column with the following column formula:
=IF(ISBLANK(JOIN([Leftmost Date Range Column]@row:[Rightmost Date Range Column]@row)), 1, 0)
Then, you can filter your report to filter out the rows with this checkmark.
Alternatively, you can create filters in the report that say "If [Date Range Column] is not blank" or "If [Other Date Range Column] is not blank" and so on and so forth. However, depending on the number of date range columns you have in the sheet and how often these columns are added, this becomes too tedious to be a very efficient solution. I would opt for option 1.
Hope this helps!:)
Answers
-
I think there are a couple of ways you could accomplish this. In the sheet, you could create a helper checkbox column with the following column formula:
=IF(ISBLANK(JOIN([Leftmost Date Range Column]@row:[Rightmost Date Range Column]@row)), 1, 0)
Then, you can filter your report to filter out the rows with this checkmark.
Alternatively, you can create filters in the report that say "If [Date Range Column] is not blank" or "If [Other Date Range Column] is not blank" and so on and so forth. However, depending on the number of date range columns you have in the sheet and how often these columns are added, this becomes too tedious to be a very efficient solution. I would opt for option 1.
Hope this helps!:)
-
That first formula worked, Brian! Thank you so much!
-
Glad to hear it!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives