-
Alerts
Hi, I am new to Smartsheet - early indication is it is an excellent piece of software and will help me enormously. I just cant seem to find a way of alerting the assigned to person (of the following task) once the previous task has been marked as complete. I would have thought this was quite a common task but cannot see…
-
Importing rows from Google Forms
Hi, I'm setting up a form in Google Forms to collect data from users. The reason I am doing this using Google Forms instead of the native Smartsheet form solution is because I need to add logic in the form so that some fields become mandatory to be answered depending on a previous selection. Well, the issue I'm facing is…
-
Form Submission Automation
Faculty can submit a request for a course copy via a Smartsheet form I created. In the form, they are required to enter the name of their Program Director/Chair. If the name of the person requesting the course copy is different than the Program Director/Chair, I'd like to send an automatic request for approval from the…
-
Exporting options in Dynamic View
Currently, there isn't a way to export or print a dynamic view report. How do I create a report that provides my vendors with up to date status on all deliverables, allowing them to also be able to export the information onto an excel spreadsheet. My question is how can I design pull communication within a dynamic view…
-
Hi SS Community! Please help if you can...
Help, I'm trying to access an external smartsheet but am unable because I'm logged into Smartsheet with an email address that is different from the one the external ss owner sent to. After my account was originally set up, my IT group had to change my email address but it never got changed in my SS account. Any ideas? :)
-
Force Comment Entry
what code could I use, in a cell or range of cells, that would "force" a user to input a comment in a certain cell based on their selection in another cell? I have attached an example from my sheet - I would like, if a user chooses a "3" in column "sub rating", they are forced to enter a comment in the "comments" cell.…
-
Construct Predecessor Alert
Hi! I am struggling with how to construct an alert for an assigned task where by it is sent when the predecessor task is completed. Any suggestions? (without having to set one up for every single line?)
-
Licensed User deleted what happens to the associated License?
When a Licensed User is deleted what happens to the associated License?
-
Workflow question
Here is the what I'm trying to accomplish..... I have a column for production area, which could be A, B, or C. I also have a column for supervisor. I want a workflow that sends an email to the supervisor, depending on which production area is selected. I'm not even sure I need a column for supervisor. Automation would…
-
Unable to Scroll While in a Formula
Hello, I am unable to scroll while editing a formula. For example, I am in line 648, and need to make it equal to line 45. If I simply hit =, and attempt to scroll out of view from 648 it gives me a #UNPARSEABLE error. I have been using SmartSheet for the better part of a decade, and never had this issue.