-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…
-
Forms timing out when filling out takes too long
We have several Smart Sheets for which the data is being populated via a form. However, the form times out if filling it out takes longer than a certain period of time. I was wondering if there is any way to avoid this "timeout" limitation and stay logged in until completing the from regardless of how many pauses will…
-
Hover function in Forms
When creating a form, it would be very useful to add details that would show when you hover over the field. It could be similar to the details section on a column where you can see the column details by hovering over the (i). One example of this use would be to provide definitions for the items in a drop down list. This…
-
The order in the form does not match with the order in the sheet
Hi group, I created a survey in Smartsheet and I see that the order of questions in the form does not match with the order of columns in the sheet. This may be because some questions were added later into the form and inserted between existing questions. The order in the form is the correct one. Do you know how to easily…
-
Is it possible to have multiple file upload fields in a form?
-
Is there a way to keep formatting from a word file (bullets/symbols) when pasting into description?
We're trying to build forms that have a guideline in the description. These guidelines are already built in word and when we paste them into the Form description the indent and symbols aren't following. Is there a way to make this format correctly? Or Is there a way to include an image in the Description section of the…
-
Trigger and execute on different sheets
Hi, how do I tie a workflow from one sheet to trigger an action on another sheet? Example, Sheet 1 has the trigger (Checkbox) that initiates a form on Sheet 2 to be sent out. Hope I can and thanks in advance! dw
-
Using the same field across different forms in one sheet
Hi there, I'm working to build a request management system using forms where requestors will simply see a dashboard with icons/text and can select the type of request they need to submit. Since each request is quite different and I want to track the different types of requests, I'd like to list "Request Type" in each of…
-
New user here... Need formula on how to count how many entries in a column are in a specific month
Hey there, I have wracked my brain for hours trying to find a formula that will allow me to count how many cells contain the month Jan, Feb, etc. So far I have tried the following.. Please let me know how I should adjust: =COUNTIFS({[ Range 1]}, @cell >= DATE(2024, 1, 1), {Certificate of Destruction Range 1}), @cell…
-
Formula to get best poll time
I have created a poll with dates as column headers and several times as multi-drop down options. It created a fantastic web-form I was able to share easily with collaborators both inside and outside my organization. My question is, is there a formula I could apply in the Sheet summary to count the best time for each date,…