-
March Question of the Month - Join the conversation and receive a badge
February’s question was so much fun, and it was a joy to read through your childhood dream. Some of you wanted to be Presidents, pediatricians, and rocket scientists, while others wanted to be singers like Dolly Parton, professional tap dancers, UPS drivers, and so much more! Now it’s time for a new question & the…
-
Community Corner Newsletter [March 2024]
Hey everyone! It's Genevieve here from the Smartsheet Community team, ready to bring you fresh news from the last month. Shout-out to @Maxwell Griffith for the newsletter in February… that wedding photo is incredible. 😍 Let’s get into what has been happening in the Smartsheet Community... and if you scroll to the bottom…
-
[GIVEAWAY] Win 1 seat to a Multi-Day Smartsheet University course
We know the Smartsheet Community is full of avid learners, and we want to support you in continuing to hone your Smartsheet skills! We’re giving away 1 seat to a multi-day course from Smartsheet University. Smartsheet University hosts a variety of self-paced and instructor-led courses, as well as certifications. Join the…
-
Changes to asset Admin permissions and new Plan Asset Admin role, now generally available!
Update on 03/25/2024: Phase 1 of the asset ownership changes is now available for all customers. Hi Community, Currently, core Smartsheet assets (such as sheets, reports, forms, and dashboards) are owned by individuals in a plan. However, the current ownership model can create friction when key stakeholders or asset owners…
-
Meet Mark Safran, our March Member Spotlight! 🎉
Make some noise for @Mark Safran, our March Member Spotlight and a Smartsheet Community Champion! Mark was recently promoted to Vice President of Operations & Technology at Chelsea Lighting (go Mark!), and lives in New Jersey but works in New York City. He was first introduced to Smartsheet in 2016 at his previous company…
-
Nominate Peak Humans & get a badge!
Hi Smartsheet Community, We loved learning about what operating at your peak looks like for you, and now, we want to give you the opportunity to recognize and celebrate others, and earn cool badges as you do it 😉 The Operate at Peak Human campaign is a celebration of humanity. Recognize someone who does a great job in any…
-
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…
-
Be aware of upcoming changes to your Smartsheet login options
Hi Community, Studies have consistently highlighted the vulnerabilities of password-based systems, including susceptibility to brute force attacks, phishing, and password theft. Such risks not only jeopardize data integrity but can lead to severe repercussions. As a part of our ongoing commitment to enhancing the security…
-
[GIVEAWAY] Enter to Win a FREE Conference Pass to ENGAGE London
Hey there, Smartsheet Community. Are you as excited as we are about Smartsheet ENGAGE coming to London May 14-15? We would love to see you there, so we’re giving away a free ENGAGE London conference pass to one of you! Enter the raffle giveaway by answering this question in the comments below: What is something you are…
-
$1B in annualized recurring revenue - Learn more and join the celebration.
Hello Smartsheet Community, We’re proud to share that Smartsheet has achieved a milestone of $1B in annualized recurring revenue. Many of you have been with Smartsheet for many years, seeing the product expand and evolve. From modest beginnings, Smartsheet has pioneered the enterprise work management category – now working…
-
Client Access to Dashboards
I have a system of dashboards that are interconnected. When I attach the URL to the client portal, they should be able to access all of the other connected dashboards for the company's departments. However, I am struggling because they are not able to access the dashboards using the given URL. I have made progress because…
-
Need help dialing in a grading formula [percentage to letter (100 to A+, 80 to B-, etc.)]
Hey all, This formula works most of the time, but it won't show the letter grade all the time, I think when its close to an in-between number. Any help making it function 100% of the time and not show an empty cell would be appreciated =IF([Week 04/01 Results]5 > 0.96, "A+", IF(AND([Week 04/01 Results]5 >= 0.93, [Week…
-
How do I prevent a category from showing up multiple times in a Pie/Donut Chart?
I made a pie chart from one of my sheets. I wanted to show how much was spent based on each category. However, in the widget it shows two of the same category in different slices. I'll include an example. Why is eLearning showing up as two separate parts instead of combined? Its the same category.
-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
Pulling Parent Data without Grandparent in a column with a column formula
I would like to pull data from a parent row into the children but with a column formula it goes back to the grandparent, how do I exclude the grandparent data?
-
email notification
I would like to set up my orientation registration smartsheet to send an automatic email to the person submitting the registration form confirming the date of the orientation. I do not want to share the sheet with everyone completing the form. I have a contact list column (this is who should receive the email) and an…
-
Countifs formula to count tasks in a range last 7 days to future 7 days
This seemingly simple formula is giving me problems. I want it to count the number of tasks due in the past 7 days through the next 7 days. I am working with the following and getting "#UNPARSEABLE": =COUNTIFS({Owner}, "Joe", {Status}, "In Progress"), {Due}, >= TODAY(-7), {Due}, <= TODAY(+7) I'd appreciate any assistance…
-
Lock a CELL
Not to be confused with locking a row or column. For sheets that are shared for editing rights but you want to lock a cell after certain criteria is reached - thereby eliminating any possible changes. Especially in fairly large data sheets where an activity log or cell histories would be an astronomical task to ensure that…
-
Smartsheet form "send me a copy of my responses" not shown
I have made several forms and in all the forms at 'settings' I have ticked the box to 'allow submitter to email a copy of form submission'. In a couple of forms this works perfect but in other forms the option 'send me a copy of my responses' is not shown. The settings in all the forms are similar so I really cannot find…
-
Formula to calculate and copy dates based on form submissions and standard timeframes
I am very new to Smartsheet and I am struggling to find the right formula for a sheet. I am working on a access sheet linked to a form. Different access categories have standard timeframes, for others, the person submitting the form will have to indicate a specific date. I was planning to have a column where to have all…