-
Smartsheet forms multiple entries for specific columns
Is there a way to be able to insert multiple lines through Form? For example If I have a field Car on the form, and I want to submit multiple cars at once on the same form, for the same row ID. If there would be + button beside Car field, and you would just add more fields of Car.
-
Using a profile matrix to drive automation on specific dates
I have a profile matrix that has a set of dates across the top (columns), row 1 and then a list of product types (Student, Teacher, Classroom) for each record, starting at row 2. On a separate sheet I have a list of products that associate to the various product types, i.e. Student Workbooks (Student), Instructional Manual…
-
Published sheet not showing filters when embedded in a website using iFrame
I have a sheet that I have filters set up to display various tasks in the Cardview. When I publish the sheet and use the Embed Code, everything works as expected with the exception of the Filters. The filter button shows but none of the saved filters are available. If I try and create a filter while editing on the website…
-
Can Formulas Reference Reports?
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person. When I go to do that and the formula asks me to reference a sheet, I am only…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Can a workflow on one sheet update specific empty cells on another sheet?
I have a sheet with a list of no longer needed items that may be useful to another group. I have setup a custom URL (custom per row/item using a unique asset number) that opens a form on a second sheet to gather the requestor's contact information. When that new row is created on the second sheet, can a workflow…
-
Workaround for all attachments sending in Update Requests...
Does anyone have a workaround for not wanting to show all the attachments for a row when an Update Request is sent with the option to attach a file? I am using Smartsheet to track RFPs and the information for each one is collected into one row on a Master Sheet using a form. This information will sometimes involve multiple…
-
if checkbox is checked, capture a value from same row and populate separate sheet
I would like to capture values from specific rows on a source sheet (Estimate Summary) when a check box is checked and send those values to a destination sheet (Allowance Log). When the checkbox is not checked on the Estimate Summary sheet, the value captured on the Allowance Log sheet should be zero. I've tried several…
-
Dropdown column
Is it possible to create a dropdown, single or multiple select, from a list in another sheet? The dropdown list will be used in a form.
-
What is best method to map data and manage ongoing changes from one Smartsheet to another?
I have been using a workflow automation to move a certain rows of information from one Smartsheet to another. These workflows are super easy and useful, but not that flexible. The provided workflow automation requires the column headers match up exactly between the two sheets in order to populate accurately. Where this is…