Why is #INVALID OPERATION displayed in a cell momentarily?

Options

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!