-
Visual grouping of data - input requested
Hi, looking for suggestions/tools on a way to show data visually grouped ideally without using parent/child relationships. e.g. if 5 initiatives were all tied to one larger objective, I'd like to only reflect the objective once (vs. in each row), with the 5 initiatives shown to the right. I know the calendar app offers…
-
It's possible to create a dynamic dropdown list in smartsheet form.
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.
-
Generate documents are generating "0" randomly in the fields
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. Where there's only text inserted - no zeros. What i've tried so far - try setting field as "number only", tried formatting…
-
CHANGE ON SITE AFTER IS CONFIRMED
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 would like when I choose from Equipment Confirmed Arrived” column the option “Confirmed” the column “Equipment Order Status”…
-
Locking Columns/Drop Down Lists
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 able to use the drop down lists? If so what other options do I have to protect the parent rows' formulas?
-
Multiple Functions per Cell/Column
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 it might take a few hours/days to input the second date. Because of this the cell is filled with #Invalad Data Type. Is…
-
Email to Name Automation/function
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 hoping that there is a more simple and less time-consuming way. Any information would be helpful, thank you!
-
Suggested or maximum payload size for Update Rows?
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 service with a sheet with >11000 rows. Is there a maximum number of row objects (and cell data) that is suggested to ensure…
-
Insert approvers name and date/ time of approval
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 options i.e. defer) The smartsheet updates to say approved or declined What i cannot figure out how to do is show who approved…
-
Sharing
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 workspace. We locked columns and hid everything on the sheet and then created reports from the sheet. Viewer access was granted…
