Formula If/Then help
I have the following columns
 Confidence
 2023 Calendar Savings
I need to have a formula in a third column that calculates the following
If confidence = 25 then multiply 2023 Calendar Savings by .25
Answers

HI @Lisa Welch
This should do the trick for you.
=if(Confidence@row=25,[2023 Calendar Savings]@row*.25,0)
Hope that helps
Thanks
Paul

Hi Paul,
I got an #unparseable?

@Lisa Welch Double check that the column names match exactly what is being used in your sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Hi Paul  yes, I have it matching but still receiving unparseable? The result would be in 2023 Calendar Adjusted at Confidence column. Here's a screenshot.
If Confidence % is 25 multiply 2023 Calendar Savings by .25 then if Confidence % is 50 multiply 2023 Calendar Savings by .50 then if Confidence % is 75 multiply 2023 Calendar Savings by .75 then if Confidence % is 100 multiply 2023 Calendar Savings by 1.

It looks like the Confidence@row needs to be changed to [Confidence %]@row to match what you have in the sheet.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Hi Paul  Here's the exact formula, but still receiving unparseable

Try a space before the % to match your column name.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Thanks Paul...That did it!
Now, how do I string together in ONE formula?
=IF([Confidence %]@row = 25, [2023 Calendar Savings]@row * 0.25, 0)
=IF([Confidence %]@row = 50, [2023 Calendar Savings]@row * 0.5, 0)
=IF([Confidence %]@row = 75, [2023 Calendar Savings]@row * 0.75, 0)
=IF([Confidence %]@row = 100, [2023 Calendar Savings]@row * 1, 0)

You would drop the second one where you have the first zero. Then drop the third in place of the second's zero. Then the fourth in place of the third's zero.
=IF(........, ..........., IF(..........., ............., IF(..........., ..........., IF(............, .............., 0))))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Thank you Paul. I'm all set. Greatly appreciate the help.

Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 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
 302 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!