Hi, I'm trying to work out how to create a formula to automatically produce % in $ value

Ian R

Approved Job Value @row * percentage complete = Percentage complete value (represented as $ Figure)

AravindGP

Hi @Ian R

What you have is the right way to do it. If you're asking how to write the formula in Smartsheet, it will be =[Approved Job Value]@row * [Percentage Complete]@row. Since you don't have any % complete values in row#1 in your screenshot, the formula for that would be =SUM(CHILDREN()). For the sum children to work, the rows below it should be indented with the indent icon or by selecting the rows and using Ctrl + ]

Ian R

Thank You, Resolved my issue.

AravindGP

Hi @Ian R

What you have is the right way to do it. If you're asking how to write the formula in Smartsheet, it will be =[Approved Job Value]@row * [Percentage Complete]@row. Since you don't have any % complete values in row#1 in your screenshot, the formula for that would be =SUM(CHILDREN()). For the sum children to work, the rows below it should be indented with the indent icon or by selecting the rows and using Ctrl + ]

Ian R

Thank You, Resolved my issue.