-
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?…
-
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…
-
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.…
-
Restrictions to primary email changes, now generally available
Hi Community, We're enhancing security by restricting end users from changing their primary email address in the Manage Email Addresses UI under Personal Settings → Profile. Now, only System Administrators can modify a user's primary email address via the User Management UI in the Admin Center, and this will be limited to…
-
Updates to Okta SAML configuration, now generally available!
Hi Community, Smartsheet has updated the Okta SAML configuration process to improve the scalability of our backend authentication architecture. With this change, SysAdmins setting up new Okta SAML configurations will need to manually enter the Assertion Consumer Service (ACS) URL and Audience Restriction (Entity ID)…
-
Calling all Marketers & Creatives — We Need Your Input! ✏️ Take Our Quick Survey ✏️
We know how important your time is, and we’re hoping you can spare just a few minutes to help us out! We’re conducting a survey specifically for marketers and creatives, and your insights would be incredibly valuable. Your feedback will help shape the future of how Smartsheet supports marketing and creative teams like…
-
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…
-
Meet our newest Smartsheet Overachievers! 🎉
Community, please join me in congratulating our 12 new and incredible Overachievers! @Brucey @Bruce Northcote @Chizu Hieida @Deena Duran @Gillian C @Lauren Dominique @Mikah Torres @Paul McGuinness @Paul Reeves @tmkj20 @Syed Muhafzal @Will Jeffords These Smartsheet customers have a passion for achieving the impossible - and…
-
What made you decide to attend ENGAGE?
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 sponsor swag by answering the question below. What made you decide to…
-
NEW! Wider dashboard canvases and dashboard zoom
Hi Community, Wider dashboard canvases and dashboard zoom are now available! Present more content with less scrolling and elegantly visualize your work on widescreen displays. To convert a standard-size canvas to a wide one, open your standard-size dashboard in edit mode and click the expand icon. We’ve also introduced…
-
Cross-Reference Formula Help with IF Statement
Hoping someone can help me fix this formula: =IF({Scope & Proposal Master List status column referenced} = "Won", INDEX({Scope & Proposal Master List project name column referenced}, MATCH([Project Name]@row, {Scope & Proposal Master List Status}, 0))) I have two sheets. In the "destination" sheet (Project Wins) I have a…
-
Lookup the text of a predecessor by starting with the predecessor #?
Here is what I'm looking to do… If I flag a task as being late, I want to look at its predecessors to find the blockage. What is the easiest way to do that? I'm sure that I will need row numbers in this solution. Let's say I have that covered (I don't). Once I have that ready. I can look at the predecessor #, go to the…
-
Total Float Function: work with multiple predecessors
Enable Total Float to work with multiple predecessors. Currently, Total Float will only calculate correctly when there is a single predecessor for an activity.
-
Download Link Removed from Backup Emails
Hi Community, To further protect your Smartsheet environment, we are removing the link which previously directly downloaded files from the backup service. The backup service allows licensed users to generate a one time or scheduled backup of a workspace, as well as generating backups of folders and sheets. Any user with…
-
Is there a way to use the current user filter just on some people and not everyone?
Is there a way to use the current user filter so that people can only see the rows they have been assigned to, but other people can see the whole sheet? I am working on a confidential project where there are 4 people in charge and need to see all tasks. But they want to assign tasks to other people without them seeing the…
-
Trigger "generate document" when the cell value (drop down) changes in a worksheet
Automation cell changes to APPROVED (it is a drop down selection) then generate a document. The document is a docusign document. Is there an issue with using a drop down selection to trigger an automation? The automation says it is successful but I don't receive a document to my email. Perhaps I need to re-look at the…
-
If Error to fix "Invalid Column Value"
What's the formula for fixing Invalid column types? Specific example: I have a text/number column for info from another sheet; one cell is a date and I'm getting the "Invalid Column Value" error. Smartsheet suggests this help article And gives the example of this for a text/number =MAX([Due Date]1, [Due Date]52) with this…
-
Is there a way to request sign-off/ approval for only certain rows in a sheet?
I am trying to create an option where all of the rows under PressRoom Action Items require a sign off or approval. I tried to do automation for this but I couldn't find a way to make it just for those particular rows. Is there another way? I also thought about forms but it didn't seem to make sense for what I am doing.…
-
Recall Automation Email
Is there an option for an email sent via automation/workflow to be recalled? For example, if an email was triggered in error by a user and would like that email to be recalled or unsent?
-
Need ideas on Creating Monthly Timesheet
Hi Smartsheet Gurus, I am planning to build a monthly timesheet for my team, which will have a) date b) no of hrs. worked for the date c) Total d) hours utilized for the whole year (sum of all months from July) e) total hours remaining (less the total hours utilized from 2000, 2000 is total assigned to a single user in a…