How do I times Rate row by Async row in one formula to get total number of each rate



  • msal
    msal ✭✭

    So pretty much a formula that will give me 278.7


  • Adrian Mandile CHESS
    Adrian Mandile CHESS ✭✭✭✭✭

    Hi @msal,

    Are you able to insert a summary row above all your data? If so,

    Add a new column to the right of Async and enter a formula in it of:

    =Rate@row * Async@row

    Add a new row above the first Rate row.

    Indent all the data rows below the newly inserted row, to make it a 'Parent' row

    In the cell of the parent row of the new column, add the formula:


    This will add all calculated products of Rate*Async below it.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!