Why is #INVALID OPERATION displayed in a cell momentarily?

John Knipper

The smartsheet has a column formula, ="https://trackpoint.[MyURL].com/projecttracking.aspx?ProjectID=" + [TrackPoint ID]@row, (I've replaced the valid URL with "[MyURL]" in the formula displayed).

Upon opening the smartsheet, every cell in the column displays, #INVALID OPERATION.

After a few seconds, the values in the columns update to display the desired URL and open the desired web page when clicked.

What is causing the momentary #INVALID OPERATION and can it be prevented?

Thank you,

John

Andrée Starå

Hi @John Knipper

I hope you're well and safe!

Usually when it happens it's in a formula heavy sheet when everything is checked when opening the sheet.

Is the sheet formula heavy?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @John Knipper

I hope you're well and safe!

Usually when it happens it's in a formula heavy sheet when everything is checked when opening the sheet.

Is the sheet formula heavy?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

John Knipper

Yes, the sheet is formula heavy; most of the columns are formulae pulling values from another sheet. This is the only column showing that message. Is there anyway to prevent it? Thank you, John