-
Format of column not reflected on completed form
We have a smart sheet that is created when a form is completed. There are multiple columns with the currency format (i.e. $25.00), we created the completed form to generate with additional fields our employees enter. However, the amounts that are formatted as currency on the sheet is not keeping the format and looks like…
-
FROM and reply to email address
So I have a sheet that has a form attached to it. We use this for our sales reps to enter sales, for an order entry person to enter them in. With this, we built automations to alert/email the order entry person of a new sale. While multiple sales reps enter orders, there are times that the FROM address shows the registered…
-
How do I change the text in an approval form so it's different from the triggered email?
When I set up an approval workflow, is it possible to change the text in the approval form from the text in the email that is triggered which contains the link to the form? Also, on the approval form is it possible to remove the "Send me a copy of my response" check box?
-
How to get VLOOUP to skip an instance if specific condition not met?
I am getting out of my depth and would like some help with a complicated equation. Background Info: Trying to streamline an item check in/out system that uses barcode SKUs and an item condition as a freeform explanation from the user. An item can be checked out/in by users and when they are checked in it will prompt the…
-
How do I restrict the range of dates in a Form input field?
I am building a reservation system and want to limit the days that a customer can select from in our Form. There are two versions on this - I want to restrict the input for the date field to only today and into the future, no days in the past. The other option I would like to do is to block certain days in the future that…
-
Drop down list from other source
Is there a possibility to fetch dropdown list from another sheet? I have huge list of predetermined entries which need to be used as dropdown it's very difficult to keep updating the same updated in the form.
-
Customized Logo and colors disappeared
I had set logo and colors for a sheet and forms. I moved the sheet to a Workspace. Now the color and logo reverted back to Smartsheet and I cannot get the logo and colors to save as they were previously?
-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…
-
SUMIFS & FIND functionality with Summary Sheets
Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are "Cost Savings" or "Risk Management". I am also trying to create a formula for just…
-
Dynamic Form Entry...
Hi there - I'm curious if there's a way to have the data entered via a form added to a specified sheet that's selected from a field... All the sheets would be created from a template. Example) --Select Job#-- ^(Drop-down menu that dynamically updates with all Sheet names contained inside a folder) --Select Part#--…