-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Cross-sheet formulas
I love that we're now able to use ranges from other sheets in formulas. I just updated a summary sheet so it uses formulas linked back to worksheets for each member of my team, rather than having the formulas on each team member's sheet and linking from there. I have a couple of questions about the best way to use the new…
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Formulas and Calculations
Duh!! I figured it out. It was simple. Dennis
-
Customizing Gantt Charts
I am brand new to SmartSheet and my team is primarily interested in finding a Gantt Chart / Timeline maker. I'm hoping the community can help me figure out the following: * Is it possible to make the gantt ribbons flat, without arrows? * Is it possible to show the task name on the ribbons? * Is it possible to make the…
-
% Date calculation
Hello, I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021). Any guidance would be greatly appreciated. Thanks,…
-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
-
Auto Assign a Predecessor in Gantt
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.). If pre-assembly is selected, for example, I always want it to…
-
Adding Rows in a sheet
When adding rows to a sheet, why does the Dashboard graphs not recalculate the graphs with the new rows? Seems the only way to fix this is to back in the graph and select the new data rows. Am I doing something wrong? Thanks David