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

So pretty much a formula that will give me 278.7
Thanks

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:
=SUM(CHILDREN())
This will add all calculated products of Rate*Async below it.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!