-
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…
-
Is any license require to submit the Smartsheet form.
Dear Sir/Madam, Please let us know, do we require smartsheet license to submit the form or free license (Viewer) is ok, Thanks and best regards.
-
Stuck Sheet
We have a sheet which is locking up every time you open it. If we have it open, you cannot click on any other sheet or the home icon to get to another sheet or workspace. We have found that we can right-click another sheet and open in a new tab, but it is very inconvenient and this is the only sheet that is doing this. Any…
-
Can an Excel form be used to populate a sheet?
The Smartsheet form logic does not support the levels of logic we currently have in an Excel form. Can the existing Excel form be imported into a sheet if the fields match the sheet columns?