-
Multi-Layer Gantt Chart
Hello, I'd like to create a Gantt chart which allows me to layer an original date range and an actual date range. This way, I would be able to show how a schedule has changed against an original base line. Ideally, i'd like to be able to see the original date as one color, and the actual date as a slightly different color,…
-
SMART Objectives Template
Hello, I tried searching for ready SMART Objectives Template. Any hints?
-
Appsheet timestamp date format
What is the trick to converting the app sheet timestamp date format to be recognised by smart sheet? On the face of it both look to be the same. timestamp format from within smartsheet is = 3/3/2018 11:48:41 timestamp format inputted from appsheet = 3/3/2018 11:48:41 I tried the DATEONLY() function on the app sheet date…
-
=NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) returns 1 when date is the
Using formula as follows should return with a 0 if the dates are the same. Why is it returning a 1 instead? A similar formula if used in Excel will return a 0, so I would assume Smartsheets would do the same. Am I missing something in the formula? Thanks, Lawrence
-
Workback
Hello, I am relatively new to smartsheet and I can't seem to figure this out (I am sure it is easy, so sorry for the dumb question). I have end dates and durations secured and I would like the sheet to populate backwords based on the end date and I can't figure out how! Thank you for your help.
-
#REF in Predecessors
What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window? I can't figure out what to do with them. I searched the Help Center and they say that #REF means "The formula references a cell which does not exist, possibly due to a row/column deletion." but this is not in a formula so I can't…
-
Obtain older version of a smartsheet?
Is there any way that I could obtain an older version of a current smartsheet I'm using?
-
Using COUNTIF or SUMIF to evaluate a date range
Hi, so I have a ColumnA that has random dates for the current year 2017. The column is formatted as a "Date" style column. My goal is to sum each date in this ColumnA by Month: Example: So to the right of each date, I want the sum of all dates that are in "January" that are in Column A. Thanks
-
Conditional: If one child is closed or past due for approval, entire hierarchy/project is closed
I have an approval request setup in my sheet, and an age column where I am tracking the number of days since the approval request was sent out. I need a method to mark the whole project tree "Closed" if any of the children's requests for approval's "age" is over (2) days
-
How to create Report/Chart/Sheet for overview of many?
We have a Sheet for every project. Every Sheet is basically a checklist. The checklists are similar but wording and order of the tasks are different. I want to create something that will bring in just the "Completed" checkbox and the Primary Column of each Sheet/checklist so that the overall status can be easily seen. How…
