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
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!