-
Using COUNTM Function to count more than one zipcodes listed in one cell
Good Evening All, I am collecting zipcodes in one column, a person could list more than one zipcode in a cell. I would like to total the number of zipcodes as the survey responses come in real time. Its okay if I count duplicates as well. This is a survey so I am using the text/number format. Issue: COUNTM does not count…
-
Why can't I see the toolbar on the sheets that came with the Sales Pipeline Template
I downloaded the sales pipeline templates and I can't see the toolbar on the 2 sheets within the template pack. Every now and then when i open the sheet it is there, but as soon as i click on a column, it goes away.
-
Stop autoformat to a percent
Hello, I have a form that collects information on a person's effort on a certain project. The field is left open & not restricted to a certain value as it depend on the person/project what is best to enter. The issue is that Smartsheet takes some of the values & multiples by 100 so that I get 100% to 500% showing often,…
-
Smartsheet Word Search: How Many Words Can You Find?
I found them all…🤣 Nothing wrong with keeping factory installed smart devices in shape. Have a good one! Cheers…Yvonne Smythe
-
Introduce yourself & get to know your peers!
Hi there, Get to know other members in the Community and take a minute to introduce yourself in the comments below. Feeling at a loss for words and need a little inspiration? Tell us where you’re from, your role, how you use or hope to use Smartsheet and a fun fact or two about yourself. (We love to learn about your…
-
Update Requests stuck in Pending status
I created and automation with an update request. I am testing it using myself as the recipient and it is showing pending for over 24+ hrs now. I am the sheet owner and the automations are set to unrestricted. Included in the automation is the add date message sent and that is working properly.
-
Employee shift categorization on resource management
How do i update a resources profile to indicate they are on a day shift or night shift so that they are grouped together (nights versus days) when viewed on the resource management calendar? I currently have employees numbered so they are listed in the order of days versus nights, but i currently have 2 employees swapping…
-
Formula to Calculate Percentage Change from Baseline
Hi, We capture scores between 1-5 each month. I'm looking to create a formula to calculate the percentage change from the baseline based on the most recent month's entry in that row. For example, baseline (starting) score was 3 in June (captured in the column "June"). Let's say it's now August and the score is 4 (captured…
-
Certification Tracking
I am looking for a way to track all of our employees certification across the company. I would like to use a form with multiple selections but the form is turning out to be too large. I don't want the employees to have to make an entry for each certification either. Things we are trying to track CERTIFICATION NAME, CERT #,…
-
Changing Primary Email Address
Once you have changed the new email address to the primary email address, is there any downside to deleting the old email address? I could not find detail regarding this in the help files.
