-
Is it Possible to Have a Form Pull From a Summary Field on the Sheet?
I believe I've seen that this isn't possible but wanted to check if anything has changed or if someone came up with a solution. I have a form where people sign up for a tour. In the main sheet I use the Sheet Summary to keep track of how many spots are left for the tour. I would like to pull from this Sheet Summary field…
-
Automating Data Mapping in Smartsheet Forms Based on Date Matching
I am using Smartsheets as a daily tracker for my prayers. I am creating a form for this tracker. I have a pre-populated Date Column and then 5 prayers columns with dropdown column options of yes and no. The idea is that every day at a specific time (end of the day) I will fill out the form and update the tracker via this…
-
Smartsheet Formula of The Week!
Hey Smartsheet Community! We're excited to introduce our DigitalRadius' Formula of the Week Email! Each week, we’ll share a practical Smartsheet formula to help streamline workflows and solve real-world challenges—all for free! This week’s formula: Flag duplicate values in a column to clean up your data and avoid errors.…
-
Sheet Title Formula?
Does anyone know if there's automation or a Formula where I can pull the Sheet Title into? For example, I want to create a "Project Name" column in a template that will bring the Sheet Title down to the row level. The use case is to then have a dashboard/report that will combine all my project sheet tasks into one. I know…
-
Links In Smartsheet Form Not Opening In New Tab
I have a bunch of links embedded in my form. When a user clicks on one of them, it opens in the same tab, negating any progress they made on the form. I looked up some solutions (putting '?&target=_blank' at the end of each link), and everything worked fine. However, after saving and refreshing the sheet/form, the links…
-
NEW! Form hyperlinks now open in a new browser tab
Hi Community! We've recently updated Forms so that hyperlinks will always open in a new tab. In order for this update to take effect, you'll need to navigate to your sheet, go to 'manage forms', delete the hyperlink, and re-add the hyperlink. Then click save and you should be good to go! With this update, you can also…
-
Auto updating form field dropdown menu based on entry submissions
I am trying to create a form that gives users dates and times from a dropdown list to sign up for coaching sessions in a way that when one person has selected a given date and time it doesn't allow another person to select that time and disables/eliminates it as an option from the form field dropdown menu. Is this possible…
-
Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
This is a problem I've heard a few times so I'm answering it in a separate post for reference in long form. I'm using the example from @WtaylorW's question over here. The basic need is to take one line and split it onto multiple lines. In this example you have a form that's inputting multiple names in different columns,…
-
Smartsheet Calendar App Open Form with New Event Button
I am running into issues with the Allow New Event on the calendar app. The required fields are set when you open details and you cannot make additional fields required. Other issues I find are fields that are included for display purposes that would normally be grayed out on an existing element (due to column formula) can…
-
Using Multiple Forms to Update a Single Row
Is there a way to use multiple forms to feed into a single row? An example would be our orthopedics program. Our coordinator collects several pieces of information from multiple departments (OR, Pre-Surgical, Med/Surg Nursing Floor, Education, etc.) Can I build something so she can create a row per patient with their ID…