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
-
Announcement
The new Smartsheet experienceIn Using SmartsheetHello Smartsheet Community! Today we are excited to announce the launch of the new Smartsheet experience. This new experience includes updates that impact the platform, including: a refreshed, modern design for most of the desktop applicat… -
Announcement
Free webinar: Capture E-signatures with Document Builder (April 22nd)In Using SmartsheetJoin us on April 22nd to learn about the redesigned document builder, now including a direct integration with DocuSign. We'll share how to quickly create custom documents with your row data, send them for e-signature, and track the signing… -
Automatically have End Date initially match Start DateIn Formulas and FunctionsIs there a way for an End Date to always automatically match to the Start Date, but for me to have the flexibility to then select a different date if needed?
-
Traffic light formula problem with two conditionsIn Formulas and FunctionsDear I have a column of% Complete (% Complete) and a Task Completion (ENDDATE) I would like to generate the following conditions: 1. Green if 100% of the task is complete and it has been given on the estimated date (which is equal to or l…Answered - Pending Review 12 views 1 comment 0 points Most recent by Bassam.M Khalil Formulas and Functions
-
Report Grouping BlankIn Using SmartsheetHi all - When I set the Grouping to be based on the Regional Practice column...it groups, but does not "Label" the groups with the Regional Practice name... I summarized a column to show that the data is there, grouped, but not …
-
How to autofill the statusIn Formulas and FunctionsHello, I need to setup a formula to have the status auto updated/filled whenever the date is entered on "EUDC Date in" column. at the moment "Status" is a drop down menu and we are manually selecting the status. Than…
-
Project dashboard milestone reportIn Using SmartsheetHas anyone figured out how to surface a milestone report to a project dashboard and only have one date column; due date? Milestone are due on a certain date (start and end same date), they are not between two dates so all I want is the tas…
-
Number of duplicatesIn Formulas and FunctionsHello, I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names? Many thanks, Pltrmgrl
-
Gantt View WeekendsIn Using SmartsheetIs there any way when using a gantt chart to get the task bars not to show running through weekends. This is not a major problem but we have had several of our customers who are more used to using MS Project asking us to show our charts in…
-
How to get minutes using this formula? The output only display 14 instead of 14:30In Formulas and Functions=VALUE(MID([12 Hour Format]@row, FIND(" ", [12 Hour Format]@row) + 1, FIND(":", [12 Hour Format]@row) - (FIND(" ", [12 Hour Format]@row) + 1))) + IF(FIND("P", [12 Hour Format]@row) > 0, 12) + 6Answered - Pending Review 13 views 2 comments 0 points Most recent by Alia AhmadKamal Formulas and Functions
-
Dependencies and fixed datesIn Using SmartsheetHello I've noticed several post on the archive asking for the same problem to be fixed, here are just 3 examples that go back to 2015. In my personal case, I would like to demonstrate customers: how the dependency was supposed to look li…Answered - Pending Review 216 views 17 comments 0 points Most recent by Emma Harris Using Smartsheet
-
Formulas for Calculating TimeIn Formulas and FunctionsI have decided to create a post that consolidates all of the different time based solutions that I have put together. Some of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through …
