-
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.…
-
Extract name from Team Column
I have a form where a user identifies all the people from different departments and input their names in the Team Column. There are times when people are not filling it out for various reasons (wasn't part of the team, forgot by the team member or the original created by user, etc..). I want to be able to check if the…
-
Creating a Calculator
Hi All - I'm trying to create a calculator in SmartSheets. I'm envisioning it as a pseudo GUI that leverages data from different sheets that we've populated, whereby we input values into this calculator, and it calculates based on predefined equations. There's ways to get close to it through a form or directly in a sheet,…
-
Linking forms in a dashboard.
Hi, Currently when one wishes to link a form in a dashboard (not display a form, i mean hyperlink! but guess it would apply to forms in a dash too) You would need to get the url first of the sheet where the form derives from. Instead, it would be handy that when adding a hotlink, it would pop-up when 'Smartsheet item' is…
-
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…
-
Saving a "Form" for later use without submitting as of yet
I have employees that try to start filling out their form as they work their 8-hour shift throughout before submitting. It seems that there are times that they leave for a while, and it automatically shuts down without saving their information that they currently had in there. I heard that there is not a way to save the…
-
Order form: Select Multiple Items and Different Quanties. Simple right? Nope.
I need HELP! There is a department in our company that fulfills office supplies orders from other departments in our company. They want a simple order form that people can use to order supplies, using Smartsheet. Simple, right? Not to me😊 They’re looking for the form to look something like this: …that spits out something…
-
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…
