-
If/then statements and automation
Hi team, I'm struggling with a request. Not sure if it's a Friday burnout or not. I was asked if we could populate one column of a sheet with a value if it could change the value of a different column. Ex: when selecting a percentage complete value (0, 25, 50, 75, 90, 100), would like for value selected to populate Phase…
-
Is there a way to auto-group form submissions/rows on the source sheet?
By default, the information that is submitted via a Form populates the Sheet's rows in oldest-to-newest order. I'd like to have the information submitted via the Form auto-group/sort according to the values in one or two of the Sheet/Form fields once it is populated to the Sheet. Would anyone be able to guide me on whether…
-
VLOOKUP Formula
Hi Smartsheet community! This may seem like a simple question but I cannot figure out this formula for the life of me. I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2. On sheet #2 it will be a list…
-
Multiselect Dropdown with Form integration
Hi SS, The community has been asking for a multiselect dropdown option since 2015. It seems there was some confusion in the other community posts, so I wanted to readdress the issue. Feature request: Dropdown menu with multiple selection option with integration into the forms. The work around of multiple columns is sloppy…
-
Multiple Selection - Formula
Hi - I have a question re: a Multi-Selection Drop Down. Right now, our one multi-select has 120 options. More often than not, people select less than 5 from the drop down. When they select from the drop-down, I have to parse what they select into codes. E.g. - Selection 1 = Code 3, Selection 2 = Code 10, etc. I'm using the…
-
SUM cells with formulas not working
Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the second sheet is asking to SUM some of the numbers in the first sheet's column and divide…
-
What formula(s) would work best for this task?
Hello Smartsheet community! I have a question regarding what formula(s) would work best for a specific spreadsheet I am building. The situation at hand: I have a spreadsheet with data that has been submitted through a Smartsheet form. This data is connected to a users alias and tracks their completion of training. There…
-
Save button is not enabled after new row is added in Smartsheet via Bridge
There is a new row added in the Smartsheet via Bridge after adding a row in another sheet. Though a new row is added successfully, the Save button is not enabled to trigger the "Row Added" event in Webhooks. Please let me know how can i receive the "Row Added" trigger once the row is added, So i can create new work item in…
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
Using forms in mobile/app
Hi Everyone, We have a form which is filled by the site team. In one field, they have to update the remarks. It is a multiline textbox. But while updating it via mobile/app, there is no option of using 'enter' key to change the paragraph. Are we missing something or is it designed that way. Thank You!