SUMIF or IF

Hi!
I am new to smartsheet and trying to figure out how to accomplish this (all contained in a single smartsheet):
Sum "Approvals" IF the "JobID" is the same and then multiply it by 400
Answers
-
Not knowing how your columns are set up not 100% sure have a couple of potentials below if they don't work with what you have provide additional details on your columns
You will need to change the name to the title of your Job ID column name and your approvals column name. If the column name has more than one work you need to surround it in brackets if it is a single word you can leave off the brackets. This below is if you want to reference the Job ID column for the criteria.
=(Sumif([JobID]:[JobID],"[JobID]@row,Approvals:Approvals))/400
The below is if you want to specify the specific criteria and not reference a row.
=(Sumif(JobID:JobID,"specify specific criteria",Approvals:Approvals))/400
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!