SUMIF or IF

kgib

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

Hollie Green

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