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:
Please refer to the attached image. I would like to create a formula to display just the "Preliminary" cost for "Atlanta - Cumming" on a separate sheet using the index/match formula but keep getting an error. Can anyone help with this? I am open to using another function as well.
Hi,
I'd recommend using a Cross-sheet formula instead.
Try something like this.
=SUMIFS({Range - Total Budget Cost}; {Range - Update Type}; "Preliminary"; {Range - Site Name}; "Atlanta - Cumming")
The same version but with the below changes for your and others convenience.
=SUMIFS({Range - Total Budget Cost}, {Range - Update Type}, "Preliminary", {Range - Site Name}, "Atlanta Cumming")
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thanks, Andree. This formula worked!!
Happy to help!
Can you maybe share the formulas you're using or the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Hi All i am trying to determine the stage that a project should have readhed by today, based on a series of milestone dates across the row however, in this particular example i am getting #invalid operation which may be due to the blanks. they are blanks because they currently have no date which is probably a flaw in the…
Looking to calculate the % of empty cells in a sheet for all rows that have data, with the intention of excluding any rows beyond my last row. I'd like to use this to motivate relevant stakeholders to completely populate the columns. Thank you.
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
