Column formula is not working.
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!
Best Answer
-
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
Answers
-
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
-
Thank you. It worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!