If/Then formula

Lisa Welch

1. Column = 2023 Calendar Savings
2. 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

Emilio Wright

@Lisa Welch Here is the formula, assuming you can only choose one Confidence.

=[2023 Calendar Savings]@row * (Confidence@row * 0.01)

Lisa Welch

Thanks Emilio,

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

Paul Newcome

I believe this is already being worked on here:

https://community.smartsheet.com/discussion/102940/formula-if-then-help