-
Web form links from report not working
I have a report that is displayed on several dashboards with links to a form. Up until recently, maybe a week ago, these links worked. Now, I get a page not found error, even though the address is correct. Has anyone else ran into this before?
-
Cross Reference Formula: No "AVEARAGEIFS" so trying to use "AVG(COLLECT(" to use multiple criteria b
I am trying to average how many days a claim has been open for a certain technician. We signify the claim being open by having a certain column being blank... here is the current formula that I have: =AVG(COLLECT({West (Tech Sheet) Range 1}, "", {West (Tech Sheet) Range 2}, "Artur Alimov - ARAL", {West (Tech Sheet) Range…
-
Misbehaving Required fields in second submission of a form
Hello, Has anyone else noticed that if you have a form that allows for multiple submissions (reload form after submission) and if you have required fields on this form, they all turn red with the required field text to them as soon as you enter anything on this form? All you need to do is to enter the first field and tab…
-
Issue with iPhones taking photos with forms
I've been trying to find a solution to this but I'm coming up empty. Long story short, we use a Smartsheet form through a web browser on a phone to collect information. It's sort of an inventory process. At the bottom of the form there is the option to submit files or photos in which we take photos to document different…
-
Taking a dashboard "snapshot" as a pdf and attaching to a given row
While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to a sheet ("sheetX" for later reference). What I want to do is try and capture a part (or…
-
Customer Form Submission Triggers Internal Form Request
We receive bid requests through web form into smartsheet. I would like that form to 1. Automatically create a form request for our estimator to fill out the estimate 2. Can the customer entered data autofill on the new form we fill out internally (items like name and address)? 3. As forms are filled out can a seperate…
-
Automatically update form link when creating new folders
Hello All! I have a folder template that has a sheet with task tracking. I have forms for entering certain tasks, Internal, External, and SCRUM tasks. Currently, I have a link to the form on a dashboard, however, the link is static and does not change when I copy the folder template and make a new project. Is there a way…
-
Is there a way to validate that a particular cell cannot be left blank or allow junk entries?
In our application, we have the smartsheet as the user interface to enter the data and then this data gets transported into the database by an API according to a set cadence. For data integrity purposes, I want to ensure that certain key fields should not be left blank or allowed junk values.
-
Automatic forms generated from report display all main sheet fields on browser
I think I've found a bug: Automatic forms generated from reports in the browser (right click in the line mover on far left > edit) display all main sheet fields on it. It doesn’t matter what columns I have chosen to display in the report creator, but in the smartsheet android app the automatic generated form of a report…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
