I have a formula attached to a column, due to this my automation is not working for the row to move from the sheet to another sheet. The automation is correct, I tested if I take off the attached column formula to cell formula and the automation works. It is only when the formula is a column formula. If there is a way to have the automation work as well as have the column formula work that would be great.
Help Article Resources
Check out the Formula Handbook template!