-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Wacky Start Date When Using FF in Predecessors
Hi there, Working to update a plan today and I noticed that the use of the FF Predecessor Type will cause some weirdness with the start date. I've put an example in the graphic above but the summary is this: If you have two tasks that have the same duration and you want their completion dates to line up, the start date for…
-
Free User can't modify sheet
Hi All, I have shared a sheet with an unlicensed use with the role as "Editor - Can Share", but it can only access to the sheet in Only View mode and it cannot edit. What i'm doing wrong? Thank you in advance, BR --Dennys
-
ODBC Connection with Visio
Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards. In Visio, you have the option to create an…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
Stacked Bar Graph - Reflect 3 columns
Can't figure out how to use 3 columns for a staked bar chart in Smartsheet. Please see attachment. For example, I'd like one column to show all costs for January, with Amy and Joe's costs would be broken out by color. Is this possible? If yes, could you please explain directions? I can only figure out how to use two…
-
I imputed a date that was 09.01.22 and yet the png shows 01.01.22
I completed a gantt chart shown here and as you can see my start date is 09.01.22 and yet the gantt charct shows january february, etc., this is ridiculous and completely ruins my chart and I didn't even input those values. If anyone could help me in removing them I would be grateful, thank you.
-
How to overrule a 0 multiplication formula returning 0 as an answer?
Hi all, haven't been able to find anything on this by searching so I'm posting. I'm hoping it is a simple fix as the formula seems very simple! I am attempting to calculate accident frequency rates at my company. I fully understand that anything multiplied by zero returns zero. However, if there have been no accidents I…
-
Maximum cross-sheet references
Once you reach this figure of maximum cross sheet references how can you get around this. I want to configure calculations to 2030. Got to June 2025 before I got stuck. Regards Steve
