Column formula is not working.



I'm currently struggling with a column formula that, surprisingly, doesn't refer to any cell or range. Despite its simplicity, it's not functioning as expected. Here's the formula I'm working on:

=IF(AND($[New break option date]@row >= [EndJanuary24]#, $[Contract start date]@row < [EndJanuary24]#), $[monthly rent income]@row * IF(COUNTIFS({Free months tenants :Tenant}, $Tenants@row, {Free months tenants :Month}, [January24]#) = 1, 0, 1), "")

Could anyone kindly review it and help me identify any errors or areas for improvement within it? I'm unsure if there's something I’m overlooking, and any insights or suggestions would be greatly appreciated.

Thank you in advance for your time and assistance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!