I am trying to use the SUM and CHILDREN Function to subtract the actual cost vs the quoted amount

CJ1234
CJ1234
edited 02/15/24 in Formulas and Functions

I am trying to use the SUM and CHILDREN Function to subtract the actual cost vs the quoted amount to determine the profit.


I have at the top of the page

Month

Week

Request

That is the hierarchy and I need to create a formula that will tell me the profit not only for each request but for the month as well.


Please help...

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!