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 2015 Posts
Archives for December 2015
Discussion List
STS dots
Is there a way to add another color dot to the Drop down, or select a new one with 5 colored dots for the STS column?
Recurring Milestones in Gantt Chart
Hi - I'd like to create a recurring milestone in a gantt chart. Do I need to create multiple activities on the list view or is there a formula that will generate a recurrence for a single activity? Thanks!
Informational Headers
Hello, Can somebody tell me if it is possible to include an informational header at the top of the sheet. In my case, this could contain the project name, team members/contacts, scope and some basic data. It could even be a text box that sits on top of the cells. I would then start my tasks beneath it. The inability of…
can i restrict data to dropdown menu only
can i restrict data to dropdown menu only
Suggestion: Ability to choose a form for update request
It would be much useful if I can choose which form should used when I sending an update request. Sometimes I need to make some fields required or read-only, but the default form of update request is not allows to do this. One possible scenario to accomplish this is to allow selecting a webform that created in underlying…
Adding Pictures
Can you add pictures into the discussion section without making it an attachment?
Typing stops when cursor is moved away from the cell
Recently I have noticed that in some of my sheets I am unable to type into cells once the mouse cursor is moved away from the cell. For example: 1. I double-click into a cell and can see the typing cursor flashing in it. 2. I type on the keyboard and see the text appearing as you'd expect. 3. Without clicking anything, I…
Color coding based on multiple columns
Hi, I have a sheet that includes Start Date, Finish Date and Status Columns. I'd like to create an IF formula that considers data in all three columns in order to create color coded balls as shown here (https://www.smartsheet.com/blog/support-tip-automate-RYG-balls). Specifically, I'd like the logic to be: If Start is…
IF statement formatting based on data in multiple columns
Hi, I have a sheet that includes Start Date, Finish Date and Status Columns. I'd like to create an IF formula that considers data in all three columns in order to create color coded balls as shown here (https://www.smartsheet.com/blog/support-tip-automate-RYG-balls). Specifically, I'd like the logic to be: If Start is…
Exclude values based on formatting
i.e. exclude red from a SUM function, so all the red values are not added up