-
October Question of the Month - Join the conversation and receive a badge
During September, you shared when and where your mind works best. Of course you all had unique preferences — early birds, night owls, the office, home, white noise, mowing the yard — but you also had quite a bit in common. So many of you get your best ideas while being active, in the shower, or after a nice cup of coffee.…
-
What view are you? Share your story and claim your badge
Hello Smartsheet Community, We love reading stories about the meaningful change you’re driving at work. Everyone has their own way of managing work, right? That's why we've ensured you always have a Smartsheet view that fits your needs. We want to hear how you are using Smartsheet and how it may change depending on the…
-
Let's celebrate our Global Community
Hello there, The Smartsheet Community brings together amazing folks across all industries, languages, and experiences from all over the world — each with a unique story, and worldview. As we get together in excitement for ENGAGE Seattle, why don’t we also gather to celebrate the peak humans who make this amazing Community?…
-
What made you decide to attend ENGAGE?
This will open during ENGAGE Seattle, starting October 7, 2024. --- Hello there ENGAGE Seattle attendees. If it’s your first time here, it’s my pleasure to welcome you to the Smartsheet Community. Participate to win a Smartsheet gift basket, full of products from local minority-owned businesses, as well as Smartsheet and…
-
Smartsheet Forward ENGAGE 2024 in Seattle: Driving better, faster outcomes
It’s been incredible connecting with the Smartsheet Community at ENGAGE in Seattle. If you joined us you heard me talk about the way we’re creating a completely reimagined experience, one designed to help you tackle your most pressing challenges with more efficiency and greater impact. If you missed the opening keynote…
-
Let’s celebrate ENGAGE with a playlist!
Hey there, Last year, the Community music fans got together to create a fantastic playlist that motivated us to achieve anything, and we loved it so much that we decided to continue the tradition. Do you also have flawless musical taste? ENGAGE in Seattle is just around the corner, so now is YOUR turn to shine! Help us…
-
Advanced Reports in Resource Management by Smartsheet now generally available!
Hi Community, We are excited to introduce "Advanced Reports," a new feature in Resource Management by Smartsheet. This release brings significant value to organizations utilizing Smartsheet and Resource Management. With "Advanced Reports," organizations can now automate their Resource Management reports—covering Time &…
-
Don’t miss anything - ENGAGE virtual activities
It’s official! ENGAGE in Seattle is sold out. Not attending? Worry not because there are multiple ways to join the ENGAGE excitement online, including right here in the Smartsheet Community. Read on to learn all the details. Don’t Miss Anything The Events topic is the place to be during ENGAGE, with all of our countdown…
-
Community Corner Newsletter [October 2024]
Hiya everyone! Genevieve here from the Community Team with October's edition of our Community Corner Newsletter. If you missed marathon-Max's update last month you can check it out here; we launched 3 more languages, the Community Playlist, and more! Community highlights Help us welcome some of our newest Member…
-
Meet Ariah Montoya, our September Member Spotlight! 🎉
Give a big cheer wherever you are for @Almonto1 (Ariah Montoya), nominated by YOU, the Community, to be our September Member Spotlight! We love to see you lift each other up. Ariah is an Events Governance Analyst at a global technology company you’ve probably heard of, and she lives in Arizona in the United States. She was…
-
Updating Previous and Latest checkboxes based on a value in another column.
Hi & Happy Friday, I'm putting together a status reporting sheet and I need to be able to update the previous and latest rows, based on a separate column, in this case the Submission Status column. Formula in the Previous column is: =IF(([HC-Row ID]@row + 1) = MAX([HC-Row ID]:[HC-Row ID]), 1) Formula in the Latest column…
-
formula
I need a formula that reflects the remaining due if not paid in full isnt checked off otherwise reflect it as a $0.00
-
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
-
Conditional Logic on Forms
It has been a LONG time since I did this, so I don't fully remember. I am setting up a test file for my new job to show them Smartsheet can do the job. Conditional logic would be a feature needed. Okay here are 2 screenshots below. For my test logic there are 3 report categories listed, and 5 fields that should show. And…
-
Formula to average scores from form responses
Hello, I am building a repository for Interview Evaluations. I have created a form to collect answers from the interviewers to rate candidates. Interviewers are asked to score candidate competencies in multiple areas. I have assigned point value to each answer (2 points for Strongly Agree, 1 point for Agree, 0 for Neutral,…
-
Using NOT with JOIN/COLLECT
Hello Everyone! I am creating a formula that returns the ID if the item type is "Book" and the status is NOT "Sold". My current formula I was trying is: =JOIN(COLLECT({ID}, {Item}, "Book", NOT({Status}= "Sold"), CHAR(10)) What is the correct way to return the ID for an item that is "Book" and the status is NOT "Sold". (Or…
-
Calendar View Integration with Outlook Calendar by filtration
Is there a way if I were in calendar view and have a filter setup (filtered by 1 specific name and task) I can have it integrated into Outlook based on that one filter instead of it all row submissions dumped into my outlook calendar at all?
-
Gathering information from another sheet, if information not on that sheet, gathering from another
I am trying to figure out a formula that will allow for me to gather information from multiple sheets (not a sum). We have multiple logs (one for each year) and i am trying to link all of this data to one sheet so it needs to look at multiple sheets for the information. I am currently only linked to one log and this is the…
-
COUNTIFS Help
I'm trying to use this formula, but am getting an error and I'm not sure what I'm doing wrong. =COUNTIFS({ElevationEscalation RCA Triage::[Triage Created]}, ">=" &TODAY(),{Elevation Escalation RCA Triage::[Triage Created]}, "<="& TODAY() + 5,{Elevation Escalation RCA Triage::[Intake Source]},"Intake/Elevation - Low") I'm…
-
Is countif working?
Hi everyone. No matter what column I use in my sheet I can’t get countif to work. Is anyone else having an issue?