If response appears, total amount in another column

Is it possible to sum a set of responses if a condition is met in another column? For example: I have a column that indicates application approval status. I have another column that indicates the total award amount. This award amount column contains amounts whether the application status has been approved or not (inprocess). I need to summarize the total amount awarded for all applications with an approval status of "yes".


  • Jeff M.
    Jeff M. ✭✭✭

    You could try a formula in a new column. =IF( [Application Status]@row = "Approved", [Amount Awarded]@row, ""). You could then summarize this column to show the total awarded amount.

  • I am actually trying to do this in a summary sheet. I don't want to build it into the application.

  • Jeff M.
    Jeff M. ✭✭✭

    If you create a sheet summary from the options to the right of the sheet. Create a text/number column named "Total Awarded" or similar, and insert a formula into that. =SUM(COLLECT([Total Award Amount]:[Total Award Amount], [Approval Status]:[Approval Status], = "Yes"))

    Or insert the formula into the cell of the summary sheet column your working on, but reference the columns from the master sheet.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!