Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Formula for Sheet Summary
Hi,
Can someone help me with my formula? I'm trying to calculate the savings percentage between the Invoice Amount and Total Spend.
This is the formula I’m using:
=IFERROR(((Invoice Amount-Total Spend £) / Invoice) * 100, 0)
But it doesn't seem to be working correctly. What's wrong with it?
Thank you.
Answers
-
hi @MarjorieB,
so I assume that: "Invoice Amount-Total Spend £" is name of the column? should not you sum the data from the column first?
invoice is also name of the column? should you not sum this column first ?
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I have been trying to genrate a formula to shorten company names: 1- For multi word names, extract the first letter of each word, skipping over short words like "and", "the", etc. 2- For single word n…
- I need to create a Summary Report for multiple fields on one sheet. I am successful in getting the COUNTIF statement to work on one of the columns, but when I add fields for a different column, the co…
- Hi, Please help me identify the error in this formula: =VLOOKUP(Barcode@row, {Main List!Barcode:Item Name}, 2, false) I'm trying to use the formula in a sheet called "Equipment Tracker" to pull in the…