-
Form Dropdowns
Is it possible to limit the dropdown options on a Form to just a subset of those in use on the corresponding sheet? In other words, the field on my sheet has 10 options but I would like users of the Form to only be able to select among 6 of those options as the remaining 4 are for internal use only.
-
Conversations (notes) now in reverse order & entry too small
I frequently create notes for line items via the Conversations feature. Until recently, these conversation notes always sorted from most recent to oldest entries. In addition, the field space provided for entering notes was larger and higher in the sheet. Now my conversation entries are automatically sorted from oldest to…
-
Transfer multiple items to a single owner
Is this really the only way? https://help.smartsheet.com/articles/520103-change-the-owner-sheet-report-dashboard Create a new workspace and copy items over? We already have established workspaces, we just want to consolidate ownership of our sheets and reports to our sys admin account. Thanks
-
SUMIF Different Columns
Hi, I have two columns [Initial Priced Amount] and [Final Account Amount], what I am trying to do is use the amount in [Initial Priced Amount] if the [Final Account Amount] is blank, but if it isn't blank then use the amount in it, the [Final Account Amount] column. I want to use it in a couple of formulas in other columns…
-
Workflow or Data Shuttle for PowerPoint Document Upload
I've done some research to see how I can have a PowerPoint file automatically uploaded to Smartsheet either via a workflow or via the data shuttle. It appears that PowerPoint isn't a supported file type and figured I'd post here to see if anyone else got this to work somehow. Thank you!
-
Can you assign a random value based on a list?
I am trying to automate the task of assigning a person to an assignment. Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new…
-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
Let folders be folders!
Let at least JPEG/PDF files be uploaded to a folder without a sheet. It is assanin to have to create a sheet to add an attachment that you have to REDOWNLOAD in order to use/export. Why not just allow a folder to have a normal folder use and upload images if I can't even export the attachments off the sheet without having…
-
formulas to reference sheet in multiple lines
Is it possible to bring information to a sheet from a reference sheet column but have it list the returned information out in separate rows? I have a source sheet with many rows that are sorted by status. I want to list out the job numbers AND the job name in another sheet, ideally side by side one on each row. I would use…
-
Formula IF/CONTAINS/COUNTIF showing UNPARSABLE error.
I have a sheet collecting answers from a survey. I have 5 columns showing Agree or Disagree questions, one for Team/Role. I want to know the percentage of the level of agreement for each of these 5 questions for each Team/Role. Meaning I want to know the percentage of agreement for Operations, DSIT PMO, etc. I'm trying to…
