need to create a dynamic dropdown list in my Smartsheet form so that data automatically pull from data sheet into my form when user click any location or year.
Hi everyone, testing this new Generate Documents function. In my PDFs there are randomly generated "0" in between numbers. Note these "0" appear ONLY where numbers are inserted into fillable fields. W…
I have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I w…
I need to be able to protect formulas in a column for the parent rows but still want people to be able be able to select child drop down cells. If I lock the column will this stop people from being ab…
Hi, Is it possible for a single Cell/Column to have multiple functions and if so, how do you achieve it? For reference, I am trying to track the amount of days between different date columns, however …
Hi, Is there a way to change an email, entered into a cell, to the name of the person? I figured that I could created an address sheet and use a cross-sheet, matching/index, formula. However I am hopi…
I've got a service that updates a sheet's rows with data from another source. It works fine on a sheet that has <5000 rows and around 19 columns, but I keep getting error 4002 whenever I'm trying the …
Hi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 opt…
It seems like there is no way to share information and ensure the user sees ONLY what you permit. We have a workspace shared to 2 ppl, Owner and Admin, We have sheets that we did not share in the work…
Hi all, I am trying to autopopulate two fields into my form from two existing columns with data. I've been following the community and so far I am able to pull one field using this formula: ="Linktoth…