Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Bug with Cell Links?

Hi all,

I'm using Smartsheet Gov and cell linking out from one source sheet pretty extensively, and I'm running into an intermittent issue where the cell being linked to will return what looks like a data structure containing the element I want, instead of just the element itself, e.g. ["A"] instead of A. Here is an example where all the cells are linked to the same cell on a different source sheet:

Screenshot 2022-11-22 113725.png

It doesn't happen all of the time, and within the same sheet it can do both ["A"] and A. I'm assuming that it's an issue of the source sheet being referenced too often. I can work around it, but ideally this would be an issue that is fixed.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions