kgib ✭✭
edited 01/03/23 in Formulas and Functions


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
    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.


    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!