Need help with a formula that is using data from 2 columns

I have a column called Building Turnover and Scheduled - Days Out. Schedule days out takes turnover - today to get a number. I want to see the value and if the value is <30, I want to add 15, if it is I want to add 30. I want all of that in another column Can you help?

=IF(OR([Scheduled - Days Out]@row1< 30, [Building Turnover]1+15), IF(OR[Scheduled - Days Out1 > 45, [Building Turnover]1 + 30))


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!