-
Celebrating the Community with Smartsheet Swag!
Exciting news, Smartsheet Community! As part of our Reward Program, we want to celebrate your contributions to the Community. Members who became Leaders & Ambassadors recently will receive surprise Smartsheet swag soon, but we also want to celebrate those of you that are slowly and steadily moving up the ranks. Seekers,…
-
Be aware of new Smartsheet invitation email experience
Hi Community, Several customers reported that in the last month, the invitation emails sent to their users to join their organizations’ plans were being automatically declined. Upon investigation, we concluded that this behavior was caused by customers’ email security software that uses “link inspection” which…
-
November Question of the Month 💭 Join the conversation and receive a badge
Hi everyone, In the October question we asked you to share something that scared you until you tried it, and you inspired us with your stories of courage. From career changes, and parenthood, to solo traveling, and jumping into a cenote — You’re incredible! Now it’s time for a new question & opportunity to earn badges and…
-
Join the conversation on STEM education and help nurture the next generation of visionaries
Hello Community Members, We've appreciated how you've supported our Sponsor X initiative and contributed to important conversations by sharing your stories and perspectives in order to shine a light on nonprofits doing meaningful and impactful work. That's why I'm incredibly excited to share with you that Smartsheet 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 Help Article! Use Bridge to delete rows
Hi Community, Thank you for your continued feedback and suggestions in the Product Ideas section - we love hearing from you! One of the requests that we're tracking feedback on is in regards to automatically deleting rows in Smartsheet. New Help Article Based on this idea's popularity, we now have new step-by-step…
-
NEW! Dashboard center alignment and mailto links now generally available!
Hi Community! We’ve released two new enhancements that should make your dashboard editing life a little easier. Dashboard center alignment: You can now center align your widgets against the dashboard canvas itself so you know where the exact middle of your dashboard is when positioning a widget. Mailto links: Any email…
-
What does it look like to operate at your peak? 💭 Join the conversation
Hello Community Members, When I browse our Show and Tell category or exploring answers shared on our Question of the Month, I'm instantly in awe of all the incredible work our members do at work, for their communities and families. I want to know what is it that recharges you and gets you in the mental and physical state…
-
Meet Peggy Parchert, our November Member Spotlight! 🎉
Allow me to introduce you to Community Champion and our November Member Spotlight, @Peggy Parchert! Hailing from Illinois, Peggy is an Exam Development Manager at Global Information Assurance Certification (GIAC). She first learned about Smartsheet in July 2016, however after she attended ENGAGE in 2018, Smartsheet’s…
-
[WATCH] Smartsheet Presents: Undercover CPO ft. the Overachievers 🤩
You may have seen a YouTube influencer from the channel FeelinSaaSy roaming the halls at ENGAGE this year. Little did you know, that was actually Smartsheet Chief Product Officer Praerit Garg going undercover as he sought to hear direct feedback from some of our Overachievers! 😮 Watch the video to see what they discussed…
-
Group Dropdown Type Columns within Reports
It would be great if we had the option to group line items in a report by options selected in a dropdown column. Ex. If you are viewing projects within a global campaign and have "country" as a column with the fixed values for all the available countries. It would be nice to be able to run a report where you could group…
-
Scrollable Text Container
Hi All, I have a two-part question regarding a form. 1) We want to create a scrollable container that displays our terms and conditions with a checkbox underneath the container. is it possible to create a scrollable container with a smartsheets form? 2) We want to have the checkbox greyed out until a user reaches the end…
-
Is there a way to set a constraint on a task's Start Date that can override a predecessor?
We have migrated a fairly complex plan from MS Project to Smartsheet and have been able to line up most of our dates. However, when Predecessors finish early on a task, the start date is impacted, as expected. In MS Project we can use constraints to say the next task cannot start early even if its predecessors end early.…
-
Graph
I would like to show the budget but just as a reference, I don't want it be a part of the chart, is that possible? Like somewhere maybe on the right hand side?
-
Control center Global update
HI Community Quick questions about Global udpates. 1) If a column name is changed in the blueprint via global updates, do all reports using the column have to be changed manually to replace the defunt column with the new one , or can global updates be used to update the report with the new column in the template folder and…
-
How to COUNTIFS with DISTINCT dates and other range/criteria?
Hi, I am trying to write a COUNTIFS formula, taking into consideration of X criteria for a range of cells in addition to DISTINCT dates within Y range. Can anyone share any insight how to write this in a formula statement? I'll provide an example below. I have a list entries in Smartsheet. They have dates associated with…
-
How can I fill in a field with a name if my Location column is a specific city?
I am attempting to autofill data into a field (person's name/contact) if the city is the one they administer. I am receiving an incorrect arguement statement error. Here is what I have so far. =IF(CONTAINS("Milwaukee", Location@row, "Michelle"), IF(CONTAINS("Appleton", Location@row, "Stephanie"), IF(CONTAINS("Madison",…
-
Barcodes scanned into a webform not converting to a number automatically in the sheet!?
Hoping someone can help with this promptly as I haven't got an answer from my support ticket from the 19th. We have a grocery store and the floor team scan the barcode of the stock coming into the store into a form and select the qty and expiry date. This goes to a landing page which has a formula in several columns to…
-
Using countif to select an option from a column
I have multiple selections in a column and when I tried to use countifs, it will not pick up the label that is combinated with other options. For example, in Column B, I have following look up values - Role 1, Role 2, Role 3, etc, but some rows have two or more roles - so in one row, it will say role 1, role 3. In another…
-
Text Join Formula
Hi there, I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked but I need assistance on changing the order of it. Course Date with Parentheses around the date and Couse Name Formula that I have: =JOIN(" ", "(" + [Course Date]@row + ")", [Course]@row) that will not work Example what I want:…