Cross Sheet Formula's

Barbara 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.

Kelly Moore

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.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Will this work for you?

Kelly

Kelly Moore

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.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Will this work for you?

Kelly

Andrée Starå

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!

Barbara S

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!

Andrée Starå

@Barbara S

Ok. Make sense!