I have a formula in a metrics sheet where I am successfully calculating the median of values that meet a specific date range: =MEDIAN(COLLECT({Resi - Financial Approval Duration}, {Resi - Enter Stage …
When collaborating and/or leveraging forms with email confirmation, if/when the title of the form contains the ampersand symbol, it errors when the email is received by the end user. An enhancement ca…
Is anyone else having this issue? The date format is showing as US format (MM/DD/YYYY) in my form builder, despite my settings being set to NZ (DD/MM/YYYY). This is the first time it's happened, and w…
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also…
Hi Community, I’m pleased to tell you about two enhancements for forms that a number of you have requested. First, you can now display your multi-select dropdown lists as checkboxes. This is a great w…
Background: We use Dynamic View to allow 3rd party vendors to enter data into our system. The initial form has about 25 fields, and built in logic to show or hide additional fields based on the initia…
Hello! I am very new to smartsheet and am trying to learn. My first project on smartsheet for my team is to develop a form that employees will use to check out and then back in an item while at work. …
Hi, I have created a logic step where if the form user fills out yes to a question, two extra rows appear. I have tested the form and it works but the additional information appears in the back-end sh…
Hi all, I just found out how to put new submissions appear on the top of the sheet, but I have old entries that I want it to be included to the top. I want these changes to apply to the old entries, h…
Hello, Quick question. So i have a drop down menu with 6 options. Is it possible to have on the form where if someone is selecting a option they, depending on who they are, can only see options 1-3? S…