or Explore Discussions

# Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

## Discussion List

• Calendar App acting strange
In Using Smartsheet
Hi, Last week the calendar app looked great, today it's truncating and showing only a few entries. I don't get why, and I have to do a presentation on it today! So I need to figure this out ASAP. It also won't let me edit the setup, the ch…
11 1
Answered - Pending Review 11 views 1 comment Most recent by Ramzi K Using Smartsheet
• Date formulas
In Formulas and Functions
I am very new to this and don't work with formulas often. I am trying to create a formula that will update the finish date automatically based on a given timeframe. For example start date is 10/12 next column gives time expected to complet…
11 1
Answered - Pending Review 11 views 1 comment Most recent by Ramzi K Formulas and Functions
• If / Then using the red, yellow, green
In Using Smartsheet
I am new to Smartsheets, so this may be a basic knowledge question ... I'm trying to use the red, yellow, green, (really just red and green) for the following scenario ... Start date is 10/1/20, due date is 10/6/20, another column for comp…
Accepted
21 8
Accepted Answer 21 views 8 comments Most recent by Andrée Starå Using Smartsheet
• Formula for Health column
In Formulas and Functions
I would like the color of the circle in the Health column (formatted from a drop down list of RYGB balls) to change based on the status selected in the previous column containing a drop down list of &quot;Not started&quot;, &quot;In Progre…
Accepted
12 7
Accepted Answer 12 views 7 comments Most recent by Andrée Starå Formulas and Functions
• Formulas on target sheet not continuing when rows are added via datamesh
When a new row is added via Datamesh to my target sheet, columns in the target sheet that contain formulas do not trickle down. This is something that is a non-issue if data is added via a form so I'm having trouble understanding why it's…
Accepted
32 2
• How can I get a column with date only, no time?
In Formulas and Functions
I currently have the auto number system created with the created field selected on a new column. I need another column with date only in order to make a dashboard, no time, is that possable?
Accepted
1 5
Accepted Answer 1 view 5 comments Most recent by Andrée Starå Formulas and Functions
• Gantt View Timeline color coded by stages
In Using Smartsheet
I am looking to develop a Gantt view that shows multiple colors on a single bar, based on the calendar, and corresponding stage of the project at that time. For example: Project XYZ, single timeline: red during planning stage (Oct 7-14), g…
12 1
Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Using Smartsheet
• Update Request System Generated Form?
In Using Smartsheet
Hello all. I sent out update requests last week and most of the recipients had multiple line items to update. I was surprised to see an 'Open Form' icon in the message but even more surprised to find that when I clicked it, a form popped…
11 views 1 comment Most recent by Andrée Starå Using Smartsheet
• Formula to calculate the Monday after a date
In Formulas and Functions
I'm looking for a way to calculate the Monday after an event date, to trigger the next step in my project plan. Any ideas? Thanks in advance!
623 12
623 views 12 comments Most recent by Ross Novotny Formulas and Functions
• Workflow Email Automation - How do I remove the link to the Sheet?
In Using Smartsheet
I have a workflow set up to send emails to Contacts on dates when courses end. All of these contacts are not Smartsheet users and are not being asked to update the sheet. The emails are simply notifications. How do I remove the link to …
Accepted
181 6
Accepted Answer 181 views 6 comments Most recent by alwayslearning Using Smartsheet