-
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…
-
April Question of the Month - Join the conversation and receive a badge
We really had a blast with March’s question, didn’t we? Whenever we ask about music, the Community comes together with all kinds of songs, artists, and genres, and that’s one of my favorite things! Hopefully your playlists have gotten some fun additions in the last month — I know mine did. Now it’s time for a new question…
-
Introducing our new video series - SmartStories!
Hi there Community, Did you participate in our Question of the Month back in November? So many of you shared the Smartsheet features you were thankful for, and we LOVED your responses. We liked them so much, that we decided to prepare something special to showcase a few: Big shout out to the very cool members featured on…
-
Welcome to the Government Community!
Hello! This is a space for Smartsheet and Smartsheet Gov users that work in all levels of government to connect, share ideas, challenges, best practices and how you are using Smartsheet and Smartsheet Gov to create impact. My name is Chris, I lead marketing for the Smartsheet Gov platform and am excited to get to know you…
-
New and improved trial user login emails, now generally available
Hi Community, We redesigned the Smartsheet email template that trial users receive when they sign up for Smartsheet with their work email. Now, during the trial signup process, users will receive a new and improved login email template where they will be prompted to confirm their work email address to secure their account.…
-
Meet Monique Odom, our April Member Spotlight! 🎉
Let’s get loud for @Monique_Odom_Comcast, our April Member Spotlight and Smartsheet Community Champion! Monique is a Business Process Excellence Manager at Comcast and calls Pennsylvania home. At a previous company, the fateful day came when she was asked to manage a platform she had never heard of before - something…
-
Smartsheet named Community of the Year!
Hello, I’m happy to share that our Smartsheet Community has been named Community of the Year in the Super Forum Customer Awards 2024. Super Forum 2024 marks the 14th year of this annual conference by Higher Logic hosted in National Harbor, MD. With Higher Logic representing over 350K online communities – this recognition…
-
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…
-
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…
-
NEW! Dashboard color themes
Hi Community! Dashboard color themes are here! Elevate the look and feel of your dashboard with just one click. No more picking random colors or spending painstaking amounts of time making sure the colors you want to use actually work together. Now you have access to 9 different color themes designed to engage and impress.…
-
COUNTIF AND for data in 2 columns
I have 5 different locations and 10 different types of devices in 2 different columns of my spreadsheet. I need get a couple of devices in each of the different locations (i.e. I have 40 various devices in 5 locations - I need to know how many of each device is in each location). That's an example, there are actually…
-
Smartsheet Calendar - Removing Completed Tasks from the View
Hello, I have been investigating the capabilities of Smartsheet Calendar and was most interested in how to use it to track multiple projects through a Smartsheet Report. The report I've created pulls from several projects, all containing a "Completed" column with checkboxes to mark status for tasks. In setting up a…
-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
-
How would you create this data for a dashboard?
I am creating a dashboard that summarizes projects that each have different metrics. I want to present them on a dashboard by each of their characteristics. For example I want one chart to show projects in progress on one chart and projects completed in another. Can I just do one data sheet and filter it someone like a…
-
RYGG ball and task status formula based on % complete and due date
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
-
New Sheet Not Showing up in Existing Report
I have a folder and inside the folder I have 25 sheets and a report that produced a listing of all the sheets in that folder, somehow when I add a new sheet in that folder, the new sheet doesn't listed on the report. Please help. thank you.
-
Using a formula that involves different sheets.
Can you use two different reference sheets in a formula? I have a data sheet where I use a formula to add up my data (sumif backlogged money). Is there a way to write a formula to pull information from two different sheets to produce a result?
-
Smartsheet business user - How to activate Resource Managment included in plan
I am the system admin of our Smartsheet business account. I have enabled Resource Management in Smartsheet setting Feature enablement. but I am unable to log into https://rm.smartsheet.com/siwith my Smartsheets account. How do i active my RM account.
-
I am attempting to create a formula that counts the number of applications approved each week?
I have five different sheets collecting information about 5 different applications and each sheet has a date-approved column. I want to collect the number of approved applications for each application type, each week (1-52). I wanted to create a column formula that will count the applications that are approved if the…