-
Resubscribe
A while back I stopped receiving notifications from work regarding my worked hours. Neither me or my boss has been able to solve the issue. It seems that I am no longer subscribed to receive them. If I unsubscribed I am unaware that I did. I need to fix this to avoid having to sit down every week with a list of hours to…
-
View an older version of gantt
I am presenting this weeks status to a client. And if I had done a snapshot a week ago then I could show the improvements since then but I failed to take a screenshot. Is there a way to look at an older version of your gantt to see where you were a week ago or x versions ago?
-
Countif in Progress and late
Dear, I am trying to reference from another sheet (Cloud), tasks that are in progress or not started but late. I tried adapting the below formulas but none is working. Can anyone help me please =COUNTIF({Cloud Range 1}, "In Progress", "Not Started), [Due Date:Due Date], <Today()) =COUNTIFS({Cloud Range 1}, Status:Status,…
-
PROJECT SCHEDULE TRACKING ON SMARTSHEET
HI I am looking for best practice to project tracking in smartsheet. I tried doing tracking of a project schedule both in MS PROJECT and Smartsheet but i get different % complete . Also i do not get overall project timelines properly matched. Where could i be going wrong?
-
large numbers changing for no reason
Typing in the number 8529101991731051 into a cell, smartsheet changes it to 8529101991731052. Any reason why?
-
Counting tasks that are late
I have a sheet where we record an anticipated complete date. We also record the status (not started, in progress, complete). We want to count the number of tasks that are late (we are past the complete date) and that have a status of either not started or in progress. How can I do that? I've been trying COUNTIFS but I…
-
Help: Status update from a reference sheet with formula
Dear, Can anyone please help me, I am trying to create a formula to generate a status update based on end date from a reference sheet (name: Cloud). =IF({Cloud Range 2},"Complete" <> 1, IF(TODAY() - [End Date] > 0, "Red", IF(TODAY() - [End Date] > -3, "Yellow", "Green"))))" I have added the header of the sheet I am trying…
-
Alerts & Reminders for "Assigned to"
Can you send reminders for upcoming due tasks to someone that is "Assigned to" a task? Currently I just send the automated reminders to shared users but, recently I had the need to just send particular tasks to selected individuals that would not be interested in the majority of the other tasks. I am thinking the answer is…
-
Limit Size of Entry on a form
I tried to search for this but was not able to find it. I have a form that I has one of the entries that I want to collect is nickname....but I can only display 8 characters.... So how do I limit the entry to restrict it to be only 8 characters? Today I am preloading the field with XXXXXXXX hoping that they will read the…
-
Dashboard Widget - Deliverable Type by Project
Hello, I am trying to determine how best to display deliverable types by project. I would like to display a widget within a project dashboard. Hoping to capture the following as an example. If there are three projects and 6 deliverable types that are required for each project to continue forward, the widget would display…
