-
Easily Set Baselines in WorkApps
In the current state, we cannot set baselines from WorkApps unless we set the desktop view to grid view. This is not an ideal experience. Don't really want the project schedule in Gantt view at all times. This may spark the need for a second enhancement request related to being able to switch views in WorkApps, which…
-
Recurring Alerts/Update Requests for an entire sheet.
Hi, I have noticed that the criteria for sending update requests to an individual in a 'contacts' column can be set for a specific date, but I am looking for the ability to send a routine monthly reminders/updates to these individuals on a recurring basis. It appears the functionality for routine updates exist at a Row…
-
I need help with a formula for Schedule Health.
Currently its working in reference to "Todays" date only. I need the formula to take in consideration the "Completed Date" and not turn "Red" or "Yellow" if the task has been completed by the "Target Date". Currently using: =IF([Target End Date]1 < TODAY(), "Red", IF([Target End Date]1 = TODAY(), "Yellow", IF([Target End…
-
Re-opening forms
Is it possible to re-open a form that is only partially completed but was submitted? We have fields in a form that need be completed at a different time and/or by a different person.
-
Why are selected dates displaying 1 day prior?
If I enter Jan 19, 2023 in the due date field, it appears as Jan 18, 2023. No changes have been made to the settings.
-
Contact Automation - Resource Manager
Hello Community- I am trying to automate contacts into tasks based upon role using a metadata column for a timing plan vs. having to fill out each contact across 50+ milestones.... The problem is we use Smartsheet resource manager and the contact column does not allow formulas to grab the contact from the metadata column…
-
project management certification prerequisites
Hello all, I'm wondering if I need to complete the core product certification prerequisite before taking the project management certification exam?
-
How to add column that shows start/finish time in minutes?
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/number one only? Would be extremely helpful, so that folks can time the work and also, if you add…
-
#UNPARSEABLE error in COUNTIF formula with OR function
Hello, I am unsure why this formula is returning #UNPARSEABLE. =COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Task List - Texas Projects PM Status}, @cell = "Red"))) It is supposed to count the number of times a name in the "FND…
-
How to create health columns individually in a dash board ? using donut chart or Pie chart?
here is the data which I had in the summary sheet. can anyone please help to create a dash board with individual health charts?