-
Require a number format
Is there a way to force input in a form to be in a specific number format? For example, require that a customer number be 10 digits, or an account number be XXXXXX-XXX?
-
Can I sum two cells together and then clear the contents of one cell without changing new total?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
-
Copy Row automation brings original sheet 'Created date' instead of showing date it was moved
Please help, I have a helper sheet that I am using to capture time stamps of when a row goes to different statuses (ex: capture time stamp when request status changes from: In Review, Pending Response, and Completed). To do that I set up a copy row automation that triggers when those statuses change. Then it copies the row…
-
When sending an automated email, is there anyway I can pick which order the customized fields go in?
Each time that I try to put certain fields from the sheet into my customized message in a certain order, it keeps changing it to something random.
-
Hi, what is the best formula to collect a text in a range of column and return it into main column?
-
Recover deleted important folder
Hi Team , I deleted accidentally very important folders, Please let me know if there is away to recover them
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
How to turn on notifications for sign-ups?
I have created a SmartSheet sign-up for an event I am hosting and it looks great. However, I am not receiving notifications when people sign up with the sheet. Instead, I've been refreshing the page every morning. Is there a way to turn on notifications for sign-ups specifically within a sheet? I've already gone into my…
-
link between sheets
Hi! I'm working with two different sheets. The first one has all marketing activities (webinars, events, trade show, etc). The second one has all the marketing assets created (Ebook, social media cards, etc). I would like to link which assets can be used for which marketing activities. A marketing activity can use more…
-
Pull Data from Another Sheet based on Criteria
Hello, Below is my master file of projects. I've filtered to show all the values based on "Automation" in the Drop Down column. Each project is designated with a project #. I want this sheet to function as a way to automatically carry over all the project #s from the master file to my new file (see below) based on all the…