same sheet formula references not highlighting

Elliott Shrader
edited 09/12/23 in Formulas and Functions

I can't seem to understand how or why my formula references sometime work and sometimes not. I use the simple [Column Name] and sometimes it works, sometimes not. Is there a trick to it that I am not seeing?

Its easier to reference another sheet because there is a way to simply select the appropriate column. Maybe there is a way to do this on the same sheet? something like Shift click or control click. I can't figure it out.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!