Formula not working from certain row onwards

Martin Suchy

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!

Martin Suchy

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!

Sandhiya

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

Martin Suchy

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.

Sandhiya

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

Martin Suchy

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!

Sandhiya

Hi @Martin Suchy

That's Great!

Have a Great Day..!

Thanks.