-
February Question of the Month - Join the conversation and receive a badge
The Smartsheet Community aims for the stars, and we love that about you! The responses to January's question were fantastic - You want to get certified, and be more present, but also do 365 kickflips, run a 5k marathon, become Smartsheet Overachievers, and so much more. The Community is cheering on you! Now, let’s explore…
-
Meet Debbie Sawyer, our February Member Spotlight! 🎉
Put your hands in the air like you just don’t care and get to know @Debbie Sawyer, our February Member Spotlight! In addition to being a newly inducted Community Champion (🎉), Debbie is the Chief Smartsheet Solutions Officer at Smarter Business Processes and lives in Southampton, England. Debbie spent the first 20 years of…
-
New and improved Safe Sharing experience, now generally available!
Hi Community, For those of you who are SysAdmins who used Safe Sharing in the past, you may have found the old experience to be a bit basic and hard to manage or audit. That’s why we’re excited to announce the new Safe Sharing experience! Now, Safe Sharing uses the scalable user interface of the inherent Smartsheet sheets…
-
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…
-
Increased Plan Insights Discoverability on Admin Center, now generally available
Hi Community, Many SysAdmins have told us that they are unsure about the difference between the Unlicensed User count on the Admin Center home page and the Internal Collaborator count in Plan Insights (which are two completely different entities). This has also led to confusion when the Unlicensed User and Internal…
-
The Smartsheet Community Goes Global! Spanish, German, and Japanese topics now available
We're thrilled to announce the launch of Global Discussions in the Smartsheet Community! At Smartsheet, we believe language shouldn't be a barrier to collaboration and understanding. That's why we're excited to offer dedicated spaces for our Spanish, German, and Japanese speaking members to connect, ask questions, and…
-
New reactivation policy for deactivated users
Hi Community, As you may already know, Smartsheet allows customers to deactivate users that have left their organization as a strong security and cost management measure, thereby enabling the reallocation of the deactivated users’ licenses. While user deactivation allows for a license to be allocated to another user, it…
-
Help Article updates
Hello Community, We’ve added new collections of articles, called learning tracks, to help you dig deeper into some areas of Smartsheet. Read on to learn more about some of the content that is now available to you. Learning tracks recently launched: Dynamic View Learning Track WorkApps Learning Track DataTable Learning…
-
Smartsheet Forward Q1 2024: Making work smoother, more intuitive, and fun
As we kick off 2024, many of you have been reflecting on your goals for the new year, and at Smartsheet we’ve been actively working on a whole bunch of new capabilities to help you reach your goals at work and to do so with fewer steps in Smartsheet. We’re also making features more discoverable, and making sure you have…
-
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…
-
Import an Excel file into exisiting Smartsheet
Hello, This might be a very basic and potentially dumb question, but I am trying to figure out how to import an excel spreadsheet into an existing sheet without overlaying the existing sheet data. Meaning when I import from Excel it deletes the existing sheet's data. How can I append an Excel import to an existing sheet? I…
-
transfer profile to personal email address
I found out yesterday that Medtronic will not be renewing my contract, as per legal there is a 2 year max on contracts. So I need to transfer my Medtronic Community profile to my personal (free account) I created. Now I bookmarked the link below from before. However I was unaware of what the timeline involved was. Like…
-
How to prevent Smartsheet API from converting certain strings to integers
Hi all, I am not sure if Smartsheet recently changed how strings and integers are formatted, but my API script has seemingly randomly began converting certain string values to integers automatically. For example, a string that leads with 0s such as "0450" is now being put into the smartsheet as just 450 and it shows up as…
-
Document generator - Font/Data error
The smart sheet document generator is showing erratic values; it used to work fine previously; however, any new document generated now creates an error; if I type ABCD in the smart sheet cell and then generate through the document generator, it will show something like (e^pp^k or olp^ifb) instead of ABCD as desired. Any…
-
Formula using TODAY when the date field is blank
I am trying to write a formula to assign colors to project tasks. It appears to be including rows where End Date is blank when the criteria is [End Date]@row < TODAY. (Same for [Start Date]@row < TODAY). =IF(Status@row = "{Link to Project Meeting Minutes}", "Green", (IF(AND([End Date]@row < TODAY(), Status@row <>…
-
Workapps access without logging in
Is is possible to create an app in workapps and have the users enter/edit information through reports without having them to log into smartsheets? I need users to provide input to specific action items but I don't want to have to set up a username and password to access SS. thanks in advance.
-
Formula help.
This discussion was created from comments split from: Count if Date Column has any dates older than 7 days.
-
Formula to look for duplicates using multiple criteria
Hello, I currently have this formula which is looking for duplicates in APPID: =IF(COUNTIF(APPID:APPID, APPID@row) > 1, "FLAG") I would like to add another formula to this which will look first at the APPID to see if they are the same, and then look in the N column to see if the name is the same. If the name is the same,…
-
Cross-sheet references maxed out
I'm building a large master reporting sheet that cross references multiple other form response sheets based on a shared "incident number". I have six more columns of data to pull over from another sheet but have maxed out the cross sheet references (100 per sheet!) This master sheet then uses that data to create pdf's. I…
-
WorkApps vs Portfolio WorkApps
I've been doing research and reading various articles in the Help & Learning Center and I'm still not 100% sure what the key differences are between WorkApps and Portfolio WorkApps created through Control Center. I know WorkApps without SCC or a Portfolio WorkApp using only 1 Blueprint can not be a multi tiered structure.…
