-
Help creating formula to update inventory automatically
The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…
-
Forms - Heading/Description
Is there a way to apply formatting to a Heading / Description field in a form? In the Description area, it looks like you can apply formatting (Bold, Underline, font color, backgroung, etc...) However, when I change these values, I don't see where this is reflected on any of the fields. As you can see in the screen shot…
-
New form builder with conditional logic now available!
Hello Community, I’m the forms product manager at Smartsheet and am pleased to let you know that we have launched a new version of our form builder that includes conditional logic. The new, full-screen form builder keeps more of the settings at your fingertips to help save time and reduce the number of clicks. You can now…
-
Populate a Form Field depending on a URL
Hi, I'm not sure if this is possible. We have a website with a list of all our technical documentation. There was an idea, to have a link next to each document, where if they click on that link it will take them to our Smartsheet form to suggest a change. We have a generic form at the moment, with a dropdown list of "some"…
-
Can I make the default values in a field specific to the selection of a previous field?
I created a form with 2 top projects X and Y and want to see different default values when selected project X than project Y , whilst keeping the same fields. Thanks,
-
Is it possible to show all or selected sheet rows on a form?
I am tasked to show all active rows from a sheet in a Smartsheet form where users can select which one they want to de-activate and provide business reasons and justifications. Is this possible?
-
Automatically Include Current Date in a Form Field on Templates
I have a form I use for data collection. In one form, it has a start date which would always be the current date. I cannot find a way to have the template always use the current date the form is generated. Instead, I have to edit the form each time I use it to add the current date, then make sure it is hidden on the form…
-
Auto Date on Forms
Does anyone know how to have a template form automatically use the current date? I have a form I use for collecting data and it has a start date, due date, etc. I would like it to automatically use the current date as soon as the Smartsheet is generated from the template. Is that even possible? TIA
-
In-House QR Code Generator
I've already shared this idea with the development team and they liked the idea, but I'm curious to see how the community would receive this as well. There seems to be more and more users in the Smartsheet community that are using QR codes with forms. It's not a difficult process with so many free or paid QR code…
-
How can I connect multiple sheets into 1 master sheet?
I have multiple sheets, each populated by their own form. I would like each sheet's columns imported into the master sheet and populate the same row. Is that possible?
