-
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…
-
Side-by-side fields in Forms
Similar to other form products (like Form Assembly), I would like to place/format fields within the form with more flexibility. At the most basic level, I'd like to place 2 fields, side by side. My particular uses would be: Dependent Name: Dependent Age: And also: Income Type: Income Amount: I actually could use more than…
-
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…
-
Using Smartsheet to create Time Off Request Calendar, Dynamic View, Form, Report, in Dashboard
Hi all, Through some trial and error I created a Time Off Request system for my team (80 people) I started with grid rows: Employee Email (text), Supervisor Email (text), Division (drop down), Time Type (drop down: Vacation/Personal/Admin/Comp OR Sick/Bereavment/Jury Duty), Start Date (date), End Date (date), Partial Day…
-
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,…
