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
 10.7K Get Help
 63 Global Discussions
 69 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!