If/Then formula
 Column = 2023 Calendar Savings
 Column = Confidence, which could be 25, 50, 75 or 100
If Confidence = 25 then multiply 2023 calendar savings by .25
then if Confidence = 50 then multiply 2023 calendar savings by .50 etc
Answers

@Lisa Welch Here is the formula, assuming you can only choose one Confidence.
=[2023 Calendar Savings]@row * (Confidence@row * 0.01)

Thanks Emilio,
Maybe I didn't phrase correctly. If Confidence = 25 then multiply 2023 Calendar Savings by .25

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!