-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
Does anyone know how to use "Row Link" in reports?
I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned & active tasks show across all project they're on. This gives an easy link to the project sheets,…
-
Contact List - Extract First / Last Name?
Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there a way to only get the first name?
-
Reference Sheet Summary fields in formula in sheet
I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!
-
Removing Zero Values From Chart
I am trying to create a stacked column chart to show how many Statuses are being used per section (Section for Chart) in a project plan. However, I do not want any zero values to show. I have attempted to create a report for this chart, but I cannot get the chart to look the way that I want. What I want (minus the zero…
-
Update Request Improvements
I would like to suggest: The option to "Include Parent Rows" when sending Update Requests (similar to the option when creating a Filter) in order to provide the context for the row in question. Include a link to the sheet in question from the Update Request Form, not just the email. Automatically include the Row Number/ID…
-
💡 Gantt w/Connected Dependency Slider Rows
A Gantt view template that duplicates rows with sliders to see what dependencies slide (out/in) when a date changes on the duplicated slider tasks. This helps with real time discussions for a visual dynamic work back or determining critical path impacts and overlaps.
-
Merged: "mouse over" interaction on a dashboard
This discussion has been merged.
-
Concatenating values from two columns with 20 spaces between them
Hi guys, I have a task to concatenate two strings from two different columns with formula. The values are for example SEA129 and 01. What I want to achieve is a string which will look like this "SEA129 (20 blank spaces) 01" Has anybody encountered similar issue?
-
How to calculate time in smartsheet
Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00