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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!