-
String Formula/Substitute Formula
Hello, I have two questions. Can someone help me understand the coding created at the end of this string query I use for a prepopulated form? Also, when I add a new section looking for the "Time," do I need to add an extra substitute in the formula, and do I add any "codes" at the end? Here's the formula I'm referring to:…
-
Using PowerAutomate to trigger the emailing of a Smartsheet form
Hi all, I tried digging around for this already, so I apologize in advance if this has already been answered. I'm reorienting to Smartsheet / Power Automate and I was wondering if there was a way to trigger a workflow in Power Automate to send a Smartsheet form over to someones email. This would ideally be for a form I'm…
-
Is there a way to have a form fill to different parent rows in a sheet using conditional logic?
Is there a way to have a form fill to different parent rows in a sheet using conditional logic? (Screenshot below) For instance on the form I may have them first choose if it is for an Ink cartridge check or an ink agitating, then based on what they select it would give them certain questions and fill to the correct parent…
-
Why is the branching logic in my form not working?
I have logic set up in a dropdown field that says if this field contains X, show the Y field. My issue is that the Y field is showing regardless if X is selected from the dropdown or not. Anyone know why this is happening?
-
User-selectable "Sticky" Form Response Fields
Allow users to indicate responses as "sticky" so they are prepopulated when the form refreshes. This would be helpful when users need to create groups of multiple form entries where some responses will be the same for each entry within a group, then need to change when starting the next group of entries. In my case, we…
-
Collecting Data from Smartsheet Form
I am trying to collect data using a Smartsheet Form. More specifically, I am trying to send the Form to verify that an item has been discontinued with a supplier. I have a column titled ITEM NUMBER, in Smartsheet and will manually add the Item Number, can this number auto populate into the form so my supplier doesn't have…
-
Creating a Form to Automatically Indent Tasks Under Projects in Smartsheet
I am working on a project tracker in Smartsheet and need help setting up a form that allows users to add tasks under specific projects. My main challenge is ensuring that these tasks are automatically associated with their respective main projects and indented correctly I'm struggling with the automation part.…
-
Can I show a populated form field with no ability to edit?
Hello, I'm populating 2 fields for this form and while I can hide them however I need the users to see the consultant name, at least. I put a notice but I would rather see an alternative way that shows the fields but are just locked. Thanks,
-
Choose Quantity for Drop Down or Multi Select allow multiple of same response
I am doing a boat rental form that allows the customer to request life vests. Is there a way to choose a quantity next to each size of the drop down list (S, M, L, XL)? Or is there a way to be able to not remove the selection after it is picked on a multi-select drop down list? So if they need more than one Toddler life…
-
Intermittent Attachment Error from Form "There was an error uploading the file"
We have a single user that gets the following error occasionally when making a row and attachment files using a form. About 1 in 25 times. Nobody else can recreate. When she re-enters the same data and file it works the next time. Her internet connection seems good. It happened to her on 2 different browsers. There is…
