Multiply Different Columns w/ IF(Or

Hi, I am pretty new to formulas and am having trouble merging the two formulas below. I've tried IF and IF(OR and IF(AND, not sure how to do this.

Basically, if there is a green dot, I want to multiply two @rows and if there is a blank I want to multiply two different @rows for the $ amount to be in the RENTAL COST FULL TERM column and convert it into a column formula.

=IF([Team Rental]@row = "green", [Hotel No of Days]@row * [Rental Cost per Day]@row)

=IF([Team Rental]@row = "", [Rental Cost per Day]@row * [Rental No of Days]@row)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!