-
Applying a formula for the whole column
Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not…
-
Form drop down selection query
Hi, Is it possible to create a form based off a sheet where you can select an entry already in the primary column which would then allow you to update specific other columns? I would like to have a form where I can select an entry in T Number column, then update Cal Due, In Cal checkbox and comments columns. Is this…
-
Form logic is not working
I submitted to tech support 5 days ago when discovered this and still can't get answers. I have built many many forms in the past however the logic is now not working. I dumped the form and started fresh however still has same issue. Logic is that when customer name is blank only Lot-Unit-Development should show however as…
-
Suppress Parent Row info viewing in Update request?
Users (in a child row) that roll-up are able to see private information (in the parent row) when selecting "Send copy of my response" in update request web form. Is there a way to either limit that view or disable the option for users to "send copy of my response" when completing the automated update request? When users…
-
Form Submitted but never shows up in the sheet
We had a customer submit a form on May 12, 2023 that never populated in our sheet but the submitter received a copy of data they submitted. We've reviewed the history and don't see anything on May 12. We've combed through things carefully and can't find a reason, which is unsettling. How likely is this an issue on our end…
-
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,
