-
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…
-
Text vs duration and dependencies
Hello everyone, I need to create an easy to use sheet that will allow my team to choose a task type from a drop down list that then auto-populates an SLA column and from that works out overallocation of resources. So far I have tried to do a VLOOKUP from the task type to our SLA times but that comes across as a text entry…
-
Formula issues
Hello, I am experiencing the following issue: In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. If date is lacking in the respective column, other value options are either a blank cell, or a status "Overdue". What I am trying to achieve is count how many times in…