Formula not working from certain row onwards
Hi, any advise why column formula suddenly stopped working from a certain row onwards? I've tried to add it in different column but the result is the same.
It stopped working in a row 1589.
Thank you!
Best Answer
-
Hi @Sandhiya
thank you! Actually I have figured it out - it seems like there was an issue with cell formatting of a cell used in the formula, when I changed that a few times, it started working.
Thank you, have a great day!
Answers
-
Hi Martin,
Hope you are safe and good...
When you are referring other sheets, the values you are referring should have data from that row 1589 or convert it to cell formula try using separately for that cell.
Thanks,
Sandhiya P
-
Hi @Sandhiya
hope you are safe and well too!
The formula is referring to another column within the same sheet. I converted to cell formula but not helping. Also I re-created the formula as a cell one in another column but also not working from row 1589 onwards. That seems strange to me.
-
Hi @Martin Suchy ,
Thanks for your reply, May I know the columns details and formula(atleast for one row), so that let me check it from my end what is the issue.(If you are comfortable means)
Thanks,
Sandhiya P
-
Hi @Sandhiya
thank you! Actually I have figured it out - it seems like there was an issue with cell formatting of a cell used in the formula, when I changed that a few times, it started working.
Thank you, have a great day!
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives