-
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…
-
[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…
-
Welcome to the Healthcare & Life Sciences Community!
This is a space for Smartsheet users that work in the Healthcare and Life Sciences industry to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform Healthcare & Life Sciences. Our Smartsheet team will be sharing helpful resources, upcoming industry events, discussion questions, and…
-
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…
-
New and improved user invitation email now generally available!
Hi Community, You now have access to the new and improved user invitation emails that new users receive when they are invited to join a Smartsheet plan! Additionally, we updated the interstitial screen shown when new users click the “Accept” button in the invitation email. This is the first of multiple phases to modernize…
-
Update sheet/report in email notification itself
Does Smartsheet allow you to directly update task statuses from within email notifications for reports itself instead of opening sheets or reports?
-
Smartsheet Merge for Google Docs authentication error
Hi, I'm having an issue with the Google Add-On Smartsheet Merge for Google Docs authenticating. I have read the following document: Smartsheet Merge add-on for Google Docs | Smartsheet Learning Center. As well as other articles in the Smartsheet Community and Google search and help results. After I click Connect to…
-
Assigning people to tasks randomly and with a condition
Hello, I would like to randomly assign service representatives tasks, but only those who meet the criteria of already completing a task previously assigned to them. I would like to create a workflow or formula that would assign individuals on their availability and at random. Any suggestions?
-
Broken Approval Workflow
Hi all! After a form is submitted, it needs 2 approvals. The first is approval is routed to the designated "Division Manager." During our test run, the Division Manager is able to receive and approval/ reject the submission. After the Division Manager approves, it is then supposed to route to the designated "Vice…
-
Why won't my automation to record dates work?
I am trying to record a date for each of our statuses listed below. Approval Pending, Approved, Denied, In progress, Completed, and Removed Most of these statuses are updated by a formula when dependencies are met on my sheet. The formula for the statuses is working correctly, but for whatever reason the In progress,…
-
Control Center Portfolio Report - Orphaned Data
Hello community, I'm new to control center and will attend the blueprint class next week. The Smartsheet services team created our portfolio solution and I own administrative responsibilities for the solution. We have a dashboard portfolio summary report that links to portfolio metrics report, it's searching for completed…
-
CountIfs Function to Determine if Completed on Time
Hi, I am trying to put together a formula sheet from our data in our inventory. Within the inventory, each project is assigned to someone and given a due date, they will manually enter their completion date. I want the formula to count # of projects someone completes on time. Here is my current formula: =COUNTIFS({Assigned…
-
Converting Multiple IF function instances to column formula
Hi, I am trying to set up time sheet for employees where formula in the column will calculate their income for hours worked. Employees are using form to enter their hours. I have set up their individual hourly rates in the summary sheet. "Amount Earned" Column contains formula. Formula is: =IF(Name1 = "Worker1",[Work…
-
Row Delimiter in a formula?
Hi all, I have a sheet that contains hierarchy, I needed to make a dynamic view and maintain the hierarchy, which I partially achieved with formula columns. Long story short, I have a parent cell (program) and children cells (parts). In dynamic view I want to have 'program' in the main view, which I achieved and 'parts' in…
-
I Need Help with IF Formula for Progress Bar Symbol Column to Function Accordingly
I'm trying to set up our Carpentry Shop's Progress Bar by how many hours they've used from the total hours they were assigned to use for the project. The following screenshot shows an example. The carpentry shop was assigned a total of 80 hours to use. So far they've used 40 hours. The progress bar's formula then updates…