-
Incomplete work left to go
Is there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)? It seems like networkdays should get part of the way there but it seems like i need an "if" statement to look at complete. Is there another way to get there that…
-
Project Resource View
I am trying to get the Project Resource View to work. However, I am having a few issues. 1. Only one name is showing up in the Project Resource View. How do I get other people who are assigned to tasks to show up? 2. The allocation shown for the one person who does appear in the Resource View is only showing up for one…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Saving smartsheet in Google Drive
I can't seem to figure out how to save my Smartsheets directly into Google Drive. I have the Smartsheet Google app, and when I'm within Google Drive, it will allow me to create new Smartsheets directly from Google Drive, and then they appear in my Drive and shared folders. However, our team already has several Smartsheets…
-
Looking for a way to send an automated email when a task's status changes
One of our key uses of SmartSheet is to collect requests from our customers and manage these requests. I would really like to be able to send an email to the requestor when their request is assigned to someone on our team, and again with each status change. Has anyone developed something like this? I saw a post about…
-
Contol Center: Program/Workspace Relationship
Hello All, I am working to better understand the Control Center application to help my department use this tool at our University. Any information you can provide regarding my question below is much appreciated. What is the relationship between programs in the control center and workspaces in smartsheet? Can a program…
-
Push to someone else's Google calendar
How can I push a task to someone else's Google Calendar?
-
SSO usin SAML question
Hello Support Community. We have setup SSO using SAML and it appears to be working fine for licensed users. Unlicensed users on our email domain are asked to create a password (therefore a new account). Can I assume it is expected behavior that only licensed users will be able to take advantage of the SSO configuration?…
-
Webform Error message - can anyone help?
Hello , We use smartsheet webforms for daily reports for some of our volunteer workers..this works fine when the forms are filled out on a computer, however when filled out in our school app and submitted, they get the attached error message saying "this form is not found". Despite this, we still receive the reports into…
-
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…
