Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Has anyone had success using the sumifs function as part of cross-sheet formulas?
I have been giving it a whirl and haven't had much luck. I am not sure if it is even possible, and if is then I'm not sure what I'm missing.
It is possible. Are you able to give more detail about your specific need?
Thanks Paul. I have an sheet set up to track payment income and related dates of payment et al.
Within that sheet I wanted to track income per week so I added some columns to the left of the sheet to roll-up the data I need, then have this data appear in a Dashboard/Sight. Now that the formulas work I hide the columns so they're out of sight.
I'd like to instead have the data on a separate roll-up sheet and keep things cleaner.
On my original sheet here is one of the formula examples:
=SUMIFS([Gross Invoice Amount]:[Gross Invoice Amount], [Date Payment Received]:[Date Payment Received], <=[Payment Week]3, [Date Payment Received]:[Date Payment Received], >=[Payment Week]2)
Attached is a snapshot of the columns & rows. Dates are added manually (for now).
Ideally I'd like to have these formulas/calculations on a separate roll-up sheet, so I can add add'l Parent/Child organization, sorting etc to my source sheet.
Let me know if this sheds enough light.
Ah. Ok. When you are building a formula, in the dropdown "help" box you will see a link that says "Reference Another Sheet". Simply click the link then select the appropriate sheet you want to pull the data from. Instead of having "[Gross Invoice Amount]:[Gross Invoice Amount]", it will look more like "{Sheet Name Range 1}". You can do this for each of your ranges whether it be the sum range or a criteria range.
Does that help, or do you need more detail?
Hi Paul - that worked finally - thank you for clarifying and helping out!
cheers,Chris
Excellent! Happy we could help.
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
I have #'s that pull from each project into each sheet's - sheet summary. Those then get pulled into a sheet summary report. They are currently grouped by what channel they are in. Each column gives a total sum. I was asked to see if we can combine the total sum into one number, so it shows how many total SKU's are being…
