Hi, My Cross Sheet formula =IF( is displaying the same results when I drag formula down dest column
Answers
-
Here is a snippet of the Master Sheet, in the Category column I'm only needing the ones that indicate "consumable".
-
No. I mean add all of the extra columns that are solely on the Consumables sheet to the Master sheet. Hide them on the Master sheet. Create a report based on the Category column containing "consumable". Then you can pick and choose which columns are shown in the report even if they are hidden on the Master. Using this route, the Report replaces the Consumables sheet.
-
Here is a snippet of the Consumable sheet, the highlighted columns indicates the columns that mirror the Master sheet and I would like to be pulled into this sheet automatically.
-
Ok. SO take the columns that are NOT highlighted, add them to the Master Sheet, then hide them.
Then create a new Report that looks at the Master Sheet. In the "What?" section, select the Category column and then enter a criteria of being "consumable". Then click on the "Columns" button in the Report Builder and select whatever columns you want displayed to include the columns hidden on the Master Sheet.
-
Hello Paul,
Thanks for your insight, I will certainly contemplate that course of action with the user.
-
Happy to help. 👍️
-
That is a great alternative, however I'm still curious to why my cross reference formula only worked when selecting referencing a single cell and got an error when trying to reference the entire column?
-
Both ranges need to be of the same size. So if one is a single cell and the other is a full column, you will get an error.
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
- 145 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!