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…
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…
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?
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…
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…
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.
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?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
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…
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…