I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.


The formula works, but it is not solving the equation and is giving me the words of the equation instead

=IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!