Formula using a Checkbox to display a price in budget column
I need a little help with a formula. Please see the sample image attached.
Once I get approval on a price (one of the 3 estimate will get selected in the "Cost approved" column, the cost amount needs to show up in the "Budget" column once I select that price.
I manually put in the $150.23 into the Budget column to show what I need the other checked boxes to do. Any help with a formula would be greatly appreciated.
Best Answer

This should work as a column formula:
=IF(COUNT(CHILDREN([Event Requests]@row)) = 0, IF([Cost Approved]@row = 1, Cost@row, ""), SUM(CHILDREN()))
Answers

This should work as a column formula:
=IF(COUNT(CHILDREN([Event Requests]@row)) = 0, IF([Cost Approved]@row = 1, Cost@row, ""), SUM(CHILDREN()))

You are AMAZING!!! Thank you so much Paul!

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!