Cross Sheet Formula's
I am struggling with a formula, I have watched several videos and read posts from others and I still cannot figure it out.
I want to pull all the costs for a specific boat (location) and have those costs (extended cost) added together on a summary sheet.
Best Answer
-
Hey @Barbara S
The SUMIFS function will achieve what you need. Because the data source is a different sheet (cross sheet) you will need to create the reference to each column manually using the formula window. The 'reference Another Sheet' link will pop up automatically whenever you begin typing in a function
Your range names will be different on your sheet. You can rename the generically generated names to make them more descriptive. You will find this good practice will help you troubleshoot formulas.
=SUMIFS({MASTER-WOMS 2023 Extended Cost column},{MASTER-WOMS 2023 Location column},[Primary Column]@row)
If you haven't seen this already, this post may be useful for you.
Will this work for you?
Kelly
Answers
-
Hey @Barbara S
The SUMIFS function will achieve what you need. Because the data source is a different sheet (cross sheet) you will need to create the reference to each column manually using the formula window. The 'reference Another Sheet' link will pop up automatically whenever you begin typing in a function
Your range names will be different on your sheet. You can rename the generically generated names to make them more descriptive. You will find this good practice will help you troubleshoot formulas.
=SUMIFS({MASTER-WOMS 2023 Extended Cost column},{MASTER-WOMS 2023 Location column},[Primary Column]@row)
If you haven't seen this already, this post may be useful for you.
Will this work for you?
Kelly
-
Hi @Barbara S
I hope you're well and safe!
To add to Kelly's excellent advice/answer.
Have you explored using a Report instead?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
THANK YOU SO MUCH KELLY! This worked! I had been trying this for hours!
Andree - I am familiar with the Report, which I love, but I also pull information off of a report for another function and Smart Sheet won't seem to let me pull from Report to Report, so I had to make this one a Sheet!
-
Ok. Make sense!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!