-
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…
-
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…
-
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…
-
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.…
-
[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…
-
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…
-
Are you attending Smartsheet Gov Forum?
Are you attending Smartsheet Gov Forum, the inaugural customer event for users of the Smartsheet Gov platform? Let us know! Introduce yourselves and get a head start on your engagement and networking! Not registered yet? Sign up while there’s still space available to come sharpen your skill set, deep dive into the…
-
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…
-
$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…
-
Archiving without control centre
Hi all, I need help! If all my projects are in one workspace and I have my portfolio dashboards/reports coming from this workspace as source sheets.. how would I archive a project? without control centre Thx,
-
Use Row@row to reference the row above in a column formula
I'm attempting to use Row@row along with an Auto Number column, in a column formula, so I don't have to manually update the formula when rows move within the sheet, but am not having any luck. The formula in the Est. RU Date column is RU Date, if it is populated, otherwise it should take the date in the Est. RD Date column…
-
Calculate quarter from date
I have a Date Ordered column and want to automatically populate a Quarter column based on the date ordered. What is the best way to write this formula?
-
Using column formula when the formula in row 1 is different to the other rows...
Hey guys, I'd be glad of some help.... I'm trying to create a column formula which uses a piece of data from the row above, which it doesn't seem to like, as it appears that the formula must be created in row 1 for it to work? I want to use column formula as I'm adding to the sheet via a form and want the column to auto…
-
Bridge Javascript/Call API & Control Center
Hello all, I have had some success with using the Smartsheet API using the PythonSDK. I am currently using Control Center to create some projects, but they get created in a workspace instead of a folder within a workspace. I have had some success with using the Smartsheet API using the PythonSDK to do something similar, so…
-
Weird issue - COUNTIF Date Cross-sheet Reference
Hi - I'm doing a very simple cross-sheet reference for a count of dates and it's not working. Sheet 1: Date column has a series of serial dates. Column14 has a formula that is not working. Sheet 2: This has a Date Completed column. The formula in Sheet 1 in Column 14 is: =COUNTIF(Date:Date, {BPD-DateCompleted}) - ...where…
-
Cannot make a formula with a cell reference to another sheet work as expected.
I'm trying to count the number of Blocker (priority) tickets for a specific Business Unit. This is the formula that SHOULD work: =COUNTIFS({BU}, [Business Unit or Dept]:[Business Unit or Dept], "JM", {Priority}, [Priority]:[Priority], "Blocker", {Ticket}, [Jira Ticket #]:[Jira Ticket #], <>""). I have validated that the…
-
Logic type table help
Can anybody suggest a way to do this. I have it working in excel, I can't seem to get it working. I have this excel formula that works. =IF(AND(A2="OT", B2="UNDER"), "LOW", IF(AND(A2="OT", B2="OVER"), "MEDIUM", IF(AND(A2="LATE", B2="UNDER"), "MEDIUM", IF(AND(A2="LATE", B2="OVER"), "HIGH", "") ) ) ) I want to compare the…
-
Children Parent % not calculating
Hello, I'm trying to build a sheet that calculates a percentage off of a Status column, but the column is not returning a percentage and the =AVG(Children) section. This is my mess of a formula =IF(IsParent@row = 0, IF(OR([Rally Status]@row = "Submitted", [Rally Status]@row = "Acknowledged", [Rally Status]@row = "Not…
-
Automation Workflow Step Through Mode
Create a mode that allows administrator to step through an automation workflow. Feature should allow stepping through one step at a time and being able to go back to the sheet to see the result to that point. Also provide method to select a point in the work flow to stop the workflow at a specific point while in this mode.…