-
CREATING INTERACTIVE FORMS / DASHBOARDS
Hi everyone I have developed forms for collecting data remotely. and dashboards for publishing the data..fairly straightforward. What I would like to do is to create an interactive form/dashboard that accesses the information in the sheet. As an example, we have a sheet that has monthly written reports (not as an…
-
Drop Down List / Column (add to list, based on User entry)
I know you can restrict the Drop Down List by what you enter into the list; however, my question is, if I create a form or have the end user enter a new entry (for the Drop Down List), can that entry now be part of the entire Drop Down List? For example: The unrestricted Drop Down List is: Apple, Banana, Pear and then…
-
Proofing Review Request
Hello, I am starting to test out the new Proofing functionality and was wondering if there are permission level limitations on who can send out the "Set up Review Request"? We have some people who are admins and some who are not who would use proofing. I want to make sure anyone can send out a review request, but wasn't…
-
Count Multiple Criteria
I'm trying to count a number of different items with multiple criteria. This is how I currently have it : =SUM(COUNTIF(Department:Department, "03 AACA Finance") + (COUNTIF(Department:Department, "03 AANJ Finance e"))) Is there an easier way since SS doesn't do arrays or do I need to keep adding the COUNTIF to the formula…
-
Forms - SmartSheet Form not the same as Form received by Action Parties to enter data
I have a Smartsheet that tracks Action Items. I created a Form that shows Action Parties data from Smartsheet and requires them to enter responses. The Form sent to Action Parties that appears in Emails and can be opened from the Email to enter responses does not contain the same cells as the Form in SmartSheet. Why? See…
-
Workflow Copy Rows...
Ok, So I'm trying to use these new workflow ( https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets ) and I'm running into an issue... So I'm in the sheet I need to copy from, and I create the workflow and select 'Copy Row' and when go to select the sheet I want to go to it does not…
-
Need to add new columns in SS to my form that I have created
I have created a New form, but them realized I needed to add additional columns to my sheet, these new columns are not populating into my form. What do I need to do to get new columns in my existing form, do I need to duplicate and then delete the old one? Please advise or send instructions?
-
Free Collaborators
I have a sheet I set up to track work orders from industrial properties around the country. I collect the data through the use of forms that i have sent via email to each of the property managers who are not licensed users. This has been great to get work orders started and assigned to people in my office. Once they are…
-
Update Request using Automated Workflow
I have created an update request in workflow and I have selected which columns I want on the update request form. Some of those columns are locked, but when I asked someone to test this for me, they can change all of the information on the Update Request Form, even the info on the locked columns. Also, the person who is…
-
Can I use a form to complete a partially-completed row?
I know forms are used to add data to a sheet, but can a form be used to complete/edit a row that is already filled in?