Formula Help
I have 2 columns.
 Annual Estimated Savings ($)
 Confidence (25%, 50%, 75%, 100%)
I need a formula that will total the value from column 1 each time 25% is chosen etc. from the amounts in "Annual Estimated Savings"
Best Answer

Perfection!! Thank you.
Answers

Can you include a screen shot of your columns? Is it like this? And would the total just show the amount that's already in Annual Estimated Savings, or is it adding it up from some other values?

Hi Naomi,
I have the formula set for Idea column so it will count how many times 25%, 50%, 75% and 100% are used in confidence % column
I need to total (with a formula) each %'s dollar value. So for example 1, 25% confidence idea Annual Est Savings would be $200,000

Hi @Lisa Welch
I hope you're well and safe!
Try something like this.
=SUMIFS([Annual Estimated Savings]:[Annual Estimated Savings], [Confidence %]:[Confidence %], 0.25)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.

Perfection!! Thank you.

Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.

Hello, I made a timesheet and wage calculation table.
The data is sent by employees using a form.
I have a problem with the time calculation.🙄
Here is the sheet.
Below is what I don't understand and I don't know where the error is.
I would be grateful if someone could check it. Thanks!

Sorry, but I messed up the example in my previous post. It shows the end time incorrectly. Below is the corrected one.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!