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. Archived 2017 Posts
Archives for January 2017
Discussion List
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…
Revision to change tracking
I changed a column to "Locked" this morning and now all of that data shows up highlighted in the track changes view. I wouldn't consider this a change worthy of highlighting in everybody's reports. Can you please remove this type of change from the highlighting filter? The same goes for changing a column format - I changed…
Formules
Hi team! Is it posible to increase more characters to input formules. Look at my project: https://app.smartsheet.com/b/home?lx=UfDi3JXtI8hV-rK6MjeRWQ
Nested IF Statements
My nested IF statment =IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 100, "Green", "Yellow")) is setting the symbol to "Yellow" when clearly the statment requires that IF([% Complete]3 = 100 (thie evaluates to true), "Green". What am I missing?
Prevent a past date being selected
Hi team, Is it possible to stop a user from selecting a previous date? Eg: We have a date coloumn, and I do not want the user to be able to select ANY DATE in the PAST. Is this possible? Thanks! Kylie
Font in Cells
Would it be possible to have a different font for only certain words in a cell? For instance, it might be important to bring attention to one or two words in a cell, so underlining, or even changing the font color, for only those words.
Emailing report if cell is changed.
Is there a way to have a report email only if a cell is set in a certain way? I have a report that I want to email but only if there the box marked review is checked. Is there a way to do this?
Is it possible to change the dates for holidays for only one spreadsheet?
I am making one for a schedule in another country and I want to be able to change that without changing the holidays for all of my spreadsheets.
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
Is there a way to make my folder structure setup the default for everyone on our account?
Thinking of this like file explorer so that all of the sheets are organized rather than in one long list for the users I add / share sheets to throughout the team. thanks