Remaining Budget
Good evening:
I have broken down my Project Budget and spent a total of 13% of my Budget. I have used the formula to get the total sum (13%). However, I am challenged with adding to the formula to get the remaining budget of 87%.
Sum Formula: =SUM(CHILDREN())
Task A: 10%
Task B: 1%
Task C: 2%
Task 0%
Thanks for the help in advance!
Comments

Hi Kam,
Try something like this.
1=100% and Spent2 is the cell for the SUM of Spent.
=1  Spent2
Was this what you wanted?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hi Kam,
Yes, Andrée is correct, if you're currently getting the value 13% and would like to achieve the difference in a separate cell you could achieve this utilizing a formula similar to Andrée's example above:
=1  [13% Column Name]1
Have a wonderful day. Thank you for contacting Smartsheet Support.
Cheers,
Eric
Smartsheet Technical Support
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 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!