Forum Discussion
Carl_61
Sep 25, 2024Iron Contributor
Formula Fix
m_tarler Formula Change/Fix Key Log Fix The formula worked perfectly fine until I added 2 columns. I'm just trying to adjust 2 numbers but the formula will not let me. This may be...
- Sep 25, 2024Thanks Matt,
Figured that out. Changed style to Information and it let me change it. I then changed it back to Stop. Works fine now. You give me inspiration thru your replies.
Carl
m_tarler
Sep 25, 2024Bronze Contributor
Hi Carl, so sry I see you left me a bunch of PMs and because the systems doesn't prompt me anymore I haven't seen them.
I remember that 'error' message was part of the data validation we applied. You will need to turn off the data validation to make the change (or you can trick it / bypass it by copying the formula and then just paste it onto the cell). I can try to look into your PMs and this specific issue later (maybe over my lunch time) and see if I can give you more detailed info.
I remember that 'error' message was part of the data validation we applied. You will need to turn off the data validation to make the change (or you can trick it / bypass it by copying the formula and then just paste it onto the cell). I can try to look into your PMs and this specific issue later (maybe over my lunch time) and see if I can give you more detailed info.
Carl_61
Sep 25, 2024Iron Contributor
Thanks Matt,
Figured that out. Changed style to Information and it let me change it. I then changed it back to Stop. Works fine now. You give me inspiration thru your replies.
Carl
Figured that out. Changed style to Information and it let me change it. I then changed it back to Stop. Works fine now. You give me inspiration thru your replies.
Carl