# Formula Help

✭✭✭✭

I have 2 columns.

1. Annual Estimated Savings (\$)
2. 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"

• ✭✭✭✭

Perfection!! Thank you.

• ✭✭✭

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

• ✭✭✭✭✭✭

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!