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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!