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?
Help Article Resources
Check out the Formula Handbook template!