Problem with save as new and column formula

Edward_Dufour

Hello,

I have a spreadsheet that has some column formulas in it. I did a "save as new" and deleted some columns that had formulas in them in the copy of the original spreadsheet. For a reason that I don't understand, the formulas in the original sheet stopped working. I don't see how modifying the copy changed the original.

Does someone have an idea of what could have happened?

Thank you for the help!

Andrée Starå

https://community.smartsheet.com/discussion/123478/problem-with-save-as-new-and-column-formula

Hi,

I hope you're well and safe!

It shouldn't if they aren't connected to another sheet together.

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Edward_Dufour

So, like I said, the formulas were working before the "save as new," and after modifying the copy, the formulas stopped working.

Andrée Starå

https://community.smartsheet.com/discussion/comment/441369#Comment_441369

Try removing the iferror part to see what the error message is.

Can you show the formula in the Invalid operation column?