I've imported a CSV File into Smartsheet that serves as my database repository for Form Fields. My Form is created on this sheet in order to reference data values within the grid for multi-select form responses, which are limited to the values provided. I would like for form submissions to land on a separate sheet as my…
Every time I put an automation to move cells to another sheet, they end up at the bottom of the new sheet. Is there a formula I can use so that they can start coming in at the top? Thank you!
Can a report automatically update and add the rows that the sheet it is being used on? My sheet is constantly being added to and I would like the report to also add the cells when the cells are added in the sheet.
Hello! We just noticed on our creative request form that the text is defaulting to white and we're unable to change it to black using the formatting options. Any help would be greatly appreciated! Thank you!
I created an intake request form and it has a status field that on submission is set to Submitted as default. A email is triggered to the team that a new intake was submitted. The process then requires someone on the team to review it and set up a discovery session. Is it possible when the status changes from Submitted to…
I have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.
Hi there, I noticed that when our employees fill out Smartsheet form, the notification I receive comes from "'<my name> via Smartsheet' via <team name>". My form/sheet is stored in a team Workspace that my team members access. So it's weird that all the notifications are showing my name on it. When it should just be the…
Hi, I have a SmartSheet form that is collecting information from our customers. We want to record their email address so I have created a field to capture that. I also want to provide the ability for the user to request a copy of their submission - part of the form functionality. The problem I want to eliminate is when…
Is there any reason why when i change a column to dropdown format, the barcode scanner doesnt show up for that cell in the webform? We have team members scanning a product barcode into a webform on delivery to record the expiry date. Due to the sensitive nature of the scanner, and some team members not being as particular…
I see how to have fields shown based one field or multiple fields with "or" statements but I'd like to only show a field based on multiple fields having certain values or using an "and" statement. Something like: If Field 1 = A and Field 2 = Z then show Field 3. Is this possible or does someone know of an easy way to do…
