-
Counting Dates
I am trying to get a formula that will count the number of times a date appears in a particular column.
-
I occasionally get #ERROR results from formulas that are only fixed by a page refresh
Occasionally I have been getting #ERROR or other error messages as a formula result in cells that previously return a valid result, and nothing related to that cell or the cells that are referenced changed. The only thing that finally fixes this is to do a hard page refresh. The attached images show this, and the only…
-
Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
-
Table in Forms
It would be extremely helpful to be able to add a data table to a form. I need to be able to ask users to provide details about, for example, grazing in multiple paddocks. My table would look like this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…
-
Deactivate form after set # of entries/submissions OR by date
It would be a great thing to be able to specify that a form be made inactive after a set # of entries. For example, my company is sending out an email with a link to a form created to gather demographic information on the individuals. The first 40 submissions are eligible for a 'free lunch' and we don't want to continue…
-
making options in dropdown unavailable if selected already
How to make dropdown options become unavailable (in both forms and sheets) once they’ve already been selected. Example: If a patient books an appointment, that time slot is automatically removed or disabled so it can’t be chosen again.
-
Forms: Source Dropdown Values from another Sheet's Data
It would be great to be able to create a form dropdown list based on the contacts in a table. Instead of having to scroll though multiples and if the list of contacts changes the dropdown list adjusts as well.
-
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
-
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
-
can i define the order of automations running?
hello can I define the order of automations running?