Hi, I'm trying to work out how to create a formula to automatically produce % in $ value
Approved Job Value @row * percentage complete = Percentage complete value (represented as $ Figure)
Best Answers

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 + ]
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

Thank You, Resolved my issue.
Answers

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 + ]
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

Thank You, Resolved my issue.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!