-
Drop down list from other source
Is there a possibility to fetch dropdown list from another sheet? I have huge list of predetermined entries which need to be used as dropdown it's very difficult to keep updating the same updated in the form.
-
Customized Logo and colors disappeared
I had set logo and colors for a sheet and forms. I moved the sheet to a Workspace. Now the color and logo reverted back to Smartsheet and I cannot get the logo and colors to save as they were previously?
-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…
-
SUMIFS & FIND functionality with Summary Sheets
Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are "Cost Savings" or "Risk Management". I am also trying to create a formula for just…
-
Dynamic Form Entry...
Hi there - I'm curious if there's a way to have the data entered via a form added to a specified sheet that's selected from a field... All the sheets would be created from a template. Example) --Select Job#-- ^(Drop-down menu that dynamically updates with all Sheet names contained inside a folder) --Select Part#--…
-
how to get sum of a column to include only certain date range
Please could someone help me with this? We have recently upgraded to be able to use the summary sheet as well as automated workflows, but neither of these have helped, and I think it maybe a simple formula issue? Basically, we use smartsheet for customers to place preorders of different products (approx 50 different…
-
Columns changed in a heavily used FORM causing chaos
I recently was asked to add several new fields to a form that is used quite a bit, globally. I've received complaints from Kenya and the USA letting me know that there was an error message when they tried to submit their application. The URL address is the same. Does it sound reasonable that they may have opened the URL…
-
Completing Form on Mobile Device without Using the App?
Hi Team, We have a form we would like to send out to our employees, but it is not mobile friendly. During our testing phases it prompts the user to create a free account when they click on the link. Is there a way for them to access the form directly? The link works on a computer/desktop and no account is needed so please…
-
Using Smartsheet Forms
I have this schedule above (took out the names/privacy) for weekly schedules with my team. Normally there is a time frame in each cell for thee week like 9:00-5:00. Each week pulls down, I just have week 3 as an example. And this form: Is there a way that I can have someone enter in their information, for example if…
