-
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?
-
Need to Create Separate Opens List from Data Sheet
Summary: I have a data sheet with a primary column listing different equipment items. Going across, there are a number of columns, 15 of which have drop downs with options N, N/A, Y, and Open Item... I need to populate a list, to a different sheet, showing only the columns, where that piece of equipment shows, Open Item.…