Why is #INVALID OPERATION displayed in a cell momentarily?


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,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!