Column formula is not working.

VirgilT

Hello,

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!

Kelly Moore

Hello @VirgilT

Column formulas do not allow absolute designations ($) or row numbers in the formula. Remove the dollar signs from in front of your row names and it should work.

Kelly

Kelly Moore

Hello @VirgilT

Column formulas do not allow absolute designations ($) or row numbers in the formula. Remove the dollar signs from in front of your row names and it should work.

Kelly

VirgilT

Thank you. It worked.