Nesting a formula in an 'if' statement - conditional values

I have two reimbursement schemes for staff vs. managers for an expense, and am using a 'checkbox' to identify managers when submitting a claim. Managers will have a 'checked' checkbox in that column.

I'm trying to use in a IF statement to behave in the following manner and can't get the syntax right.

I'm striving for, in words, "If the Manager column is checked, multiply the [Number of Nights] column in the same row by an amount, if not true, value is \$0. This plays into another formula that sums the 'claims' but catches this 'top up' for managers.

=IF([Manager]@row = 1, "([Number of Nights]@row*25)", "0")

Any tips appreciated.

Thanks,

• ✭✭✭✭✭✭

Hi

Use True to make the formula work

=IF(Manager@row = "True", Nights@row * 25, 0)

Hope that helps

Purnima

Purnima Gore

Cierr Limited

Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

https://www.cierr.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!