-
Deactivate form after set # of entries/submissions OR by date
It would be a great thing to be able to specify that a form be made inactive after a set # of entries. For example, my company is sending out an email with a link to a form created to gather demographic information on the individuals. The first 40 submissions are eligible for a 'free lunch' and we don't want to continue…
-
Can I send Welcome Letter?
Trying to figure out the Automation programming for when someone fills out a form that goes into one of my Smartsheets that if they provide their email address it will trigger a welcome letter email to be sent to them when they submit the form. Is this possible?
-
Control Center Error Message
Hi all, I was hoping someone could assist. We were previously able to provision project successfully through control center, however now the automation logs are reporting a failure. I am receiving the following error message on all of the projects I'm attempting to provision: Unable to retrieve Custom fields from Resource…
-
Formula to record and store a value at the start of each day
I am looking for a way to have smart sheet review an average time at the start of the day and record that value. I would then want visibility of that data over a range of the last 7 days. I am using this in a chart to show progression towards the goal of 21 days.
-
Formula - Dates
Hey all, We are using smartsheet as a catch-all tool. I am working on creating a Desk Hoteling booking calendar for folks and would love to see if anyone has done something similar in the past. I'd like to use a formula from a source sheet that autofills information like dates. An example: Sue sits in office 318A on…
-
Index Look Up - Help a Newbie?
Hi trying to write a very basic INDEX/MATCH formula to look up the ballpark name and ballpark address from ST Addresses and insert into Arizona Schedule. My formula is saying "no match". What am I doing wrong?! This is my formula below =INDEX({ballpark name}, MATCH(Team@row, {Ballpark}, 0)) – writing the formula here to…
-
I am receiving a zero "0" in the cell
I don't know how to ask this question. I have cell formula below. When I run the automation, I receive a "0" before the drop-down value in the cell Any help would be appreciated. Thanks
-
Industry Talk - Connect with peers in your industry!
Hi Smartsheet Community, We noticed you want more ways to connect with members in your own industries, and we think that’s a fantastic idea! Today, we’re excited to launch a new topic where you can engage with your peers — Industry Talk. This is a space dedicated to the different industries, each with its own topic and…
-
Action : change cell value
Hi Community, I feel like this is simple question, but I can make it happen. If I want to using change cell value in automation workflows, can I change the cell value by using formula? Cause I use the formula to change, the result always add ' in front of the formula…(show as the pic below) Besides, can it make the value…
-
Need formula to remove characters from a column when added
We export data from another data source and cut and paste it in the Smartsheets Column AOY Status. The issue is after we cut and paste the data there are going to be certain characters I need removed. For example: The data we cut and paste in will have Down <20 days or Down >20 days. When we cut and paste that data I would…
