SUMIF Trouble
I am trying to use SUMIF to add the dollar amount for jobs that have 100% probability. I wrote this formula: =SUMIF(Probability:Probability, "100%", [Quoted Amount]:[Quoted Amount]) and it returns a 0 but no error. Also all of the data in this sheet is linked from another sheet. Is the problem because the data is linked?
Comments

The problem might be because Smartsheets recognizes percentage formatted columns as decimals in the back end... try, =SUMIFS([Column to sum]:[Column to sum], Probability:Probability, 1)
25% will be read as .25, 50% as .5, and 100% as 1. Hope that helped! I also updated your sumif to a sumifs so you can add additional criterion if ever needed.
You will also need to indicate the column to sum. If you put this formula in the same column as the sum itself it will give you a circular reference. Make sure your summary formula is in a different column.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!