-
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…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
creating a form but not appearing in the Preview as a full form
I am a new user to smart sheet and I am working on creating a form.The problem that I am having is that all of the data for the forms are in there place but they are not appearing on forms when I do a preview of the form.
-
@ mentions not working
I am not receiving @ mention in comments even though my Notifications>Personal Settings are all checked. Other users are receiving them fine. My email appears in the dropdown as sheet collaborator. I am the owner of all the sheets. Anybody have any ideas?