Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Column Names - Tips and Tricks
1. Naming Columns: Changing a column name post-facto breaks reports and other stuff creating a lot of useless donkey work. Naming columns correctly at the get go is uber-important- think about it before comitting.
2. Make your formulas easier to read: Name columns with underscores between words, i.e "Due_Date" instead of "Due Date". When referencing a column name, Smartsheet formula generator interprets this as one string and omits the confusing additional brackets [ ] which are difficult to read and manage.
3. Hidden Column Names: Use the prefix "Z" for hidden column names, i.e. "Z_Hidden_Column_Name". Why? In the report generator, this forces those columns to the bottom of the pick list which makes them easy to idenfiy and manage.
Tell your end users not to mess with any "Z_Columns", it looks techie, so they leave them alone and won't bother you with questions like: "Hey Dude, what does "Z_Calculate_Solar_GamaFlux" mean?