community.smartsheet.com Open in urlscan Pro
162.159.138.78  Public Scan

Form analysis
0 forms found in the DOM

Text Content

___



YOUR PRIVACY

Welcome to Smartsheet! We’re glad you’re here and want you to know that we
respect your privacy and your right to control how we collect, use, and share
your personal data. Please read our Privacy Notice to learn about our privacy
practices. Manage my preferences
Powered by
Reject AllAccept All
Skip to content

 * Discussions
 * Topics
 * Support
 * Product Ideas
 * Help & Learning




Sign in
Try Smartsheet



EXPLORE. ASK. ANSWER.



Find peer-to-peer information about everything Smartsheet related – from project
management best practices to invaluable how-to guidance from fellow users and
Smartsheet experts.

Clear

SearchLoading




AREAS TO EXPLORE

About the Smartsheet Community
Get a quick tour and check out all the benefits of logging in.

Browse discussions
See what’s been recently shared and join those conversations that interest you.

Earn Badges + Swag
Let’s celebrate! Join now and start earning points, badges, and Smartsheet swag.

Share your ideas
Tell us about the product improvements you want to see and vote on existing
ideas.

Get Help with Smartsheet
Find answers to your Smartsheet questions in English, Deutsch, 日本語, and Español.

Show & Tell
Share and celebrate - whether a promotion, a new Smartsheet solution, best
practice or badge. Share the good news and cheer on others!

AnnouncementsRecent DiscussionsNewest Questions


 * MAY QUESTION OF THE MONTH - JOIN THE CONVERSATION AND RECEIVE A BADGE
   
   Last month, we asked you to share something you would try if you knew you
   couldn’t fail, and the responses showcased the beautiful diversity of our
   Community. As some of you pointed out, failure is an…
   
   Announcement
   QofMonth
   Show & Tell
   699
   9:50 pm
   81
   


 * MEET MONIQUE ODOM, OUR APRIL MEMBER SPOTLIGHT! 🎉
   
   Let’s get loud for @Monique_Odom_Comcast, our April Member Spotlight and
   Smartsheet Community Champion! Monique is a Business Process Excellence
   Manager at Comcast and calls Pennsylvania home. At a pr…
   
   Announcement
   Member Spotlight
   Community Champions
   Member Spotlight
   295
   2:10 pm
   6
   


 * THE PARADOX OF GOVERNING USER AUTONOMY
   
   Hello Community, In the world of hybrid work and AI’s promises to transform
   the workplace, IT departments find themselves in the seemingly paradoxical
   position of expanding access to information while…
   
   Announcement
   IT Management
   Show & Tell
   24
   May 8, 2024
   


 * 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 je…
   
   Announcement
   Answered ✓
   Product Announcements
   4675
   May 8, 2024
   76
   


 * COMMUNITY CORNER NEWSLETTER [MAY 2024]
   
   Hello everyone! It’s Arsineh from the Smartsheet Community team. It’s been an
   active month on Community and there’s so much I’m excited to share with you.
   In case you missed it, check out the April Ne…
   
   Announcement
   Community Corner Newsletter
   Community Corner Newsletter
   2190
   May 8, 2024
   7
   


 * CAN ANYONE HELP WITH USING INDEX AND MATCH TO PULL DATA ACROSS FROM OTHER
   SHEETS?
   
   So I tried using the page I have linked below to help me with this but I am
   running into some issues. I have created two testing sheets to use until I
   get the set up right before applying it to my wor…
   
   Answered
   Formulas and Functions
   21
   10:14 pm
   4
   


 * HELP WITH GETTING THE SUM OF MULTIPLE COLUMNS
   
   I am trying to figure out the function to get the sum of multiple columns. I
   also want to be able to apply the function the every row in my sheet. So,
   when the form dumps a new response it auto finds …
   
   Question
   Formulas and Functions
   3
   10:14 pm
   


 * COUNTIFS FORMULA
   
   I would like the below formula to look at the Associate column (external
   sheet) and find Ashley. If it is Ashely then I want it to count if there is
   an issue logged in a four column range (same extern…
   
   Answered
   Formulas
   Formulas and Functions
   82
   10:08 pm
   13
   


 * PARENT DROPDOWNS
   
   It would be amazing if there were a way to edit or add to a parent dropdown
   that can be used and updated across all sheets. This would make more builds
   possible that require many dropdown menus. Many …
   
   functionality
   Idea Submitted
   Smartsheet Product Feedback & Ideas
   4
   10:06 pm
   


 * HOW WOULD I EDIT THIS FORMULA TO ONLY COUNTIFS IN A PARENT ROW?
   
   How would I edit this formula to only COUNTIFS in a PARENT row? I'm not
   looking to add a helper column. Thanks in advance! =COUNTIFS({THD Team Locked
   In}, "1", {Billing Month}, Month@row, {APM}, "Emil…
   
   Answered
   parentrow
   Formulas and Functions
   12
   10:03 pm
   2
   


 * HELP WITH GETTING THE SUM OF MULTIPLE COLUMNS
   
   I am trying to figure out the function to get the sum of multiple columns. I
   also want to be able to apply the function the every row in my sheet. So,
   when the form dumps a new response it auto finds …
   
   Question
   Formulas and Functions
   3
   10:14 pm
   


 * NOT ABLE TO USE SEARCH BAR IN SHEETS
   
   Hello, Our unlicensed users are reporting that they are unable to search
   within a sheet using the search bar. Our Licensed users however are able to
   use this feature without any issues. Both licensed …
   
   Question
   Smartsheet Basics
   4
   9:58 pm
   


 * SORTING BY GROUPED STATUS WITH A CUSTOM ORDER
   
   I'm working on a report that has the usual project status "On track, Paused,
   On hold, In Queue, Delayed Start" etc… I currently have a list of the project
   name as a line item, then grouped by applicab…
   
   Answered
   Reports
   Dashboards
   Project Management
   Smartsheet Basics
   9
   9:58 pm
   1
   


 * CHART LINK BREAKS OVERNIGHT
   
   I display a chart in my chart that I have to re-link every day because, at
   some point, it becomes an error message. See below. Any help?
   
   Question
   Formulas and Functions
   6
   9:19 pm
   


 * DELETING OR DEACTIVATING REQUEST EMAILS
   
   Hello, I have an automation where it send a request email automatically and
   it resends the same email 2 more times both request emails. I do it this way
   as a reminder and don't have to ask them to sea…
   
   Question
   Forms
   Sheets
   Email Notifications
   Smartsheet Basics
   5
   9:13 pm
   


EXPLORE. ASK. ANSWER.

Find peer-to-peer information about everything Smartsheet related – from project
management best practices to invaluable how-to guidance from fellow users and
Smartsheet experts.
 
«1234567…100»


DISCUSSION LIST


 * MAY QUESTION OF THE MONTH - JOIN THE CONVERSATION AND RECEIVE A BADGE
   
   Last month, we asked you to share something you would try if you knew you
   couldn’t fail, and the responses showcased the beautiful diversity of our
   Community. As some of you pointed out, failure is an…
   
   Announcement
   QofMonth
   Show & Tell
   699
   9:50 pm
   81
   


 * MEET MONIQUE ODOM, OUR APRIL MEMBER SPOTLIGHT! 🎉
   
   Let’s get loud for @Monique_Odom_Comcast, our April Member Spotlight and
   Smartsheet Community Champion! Monique is a Business Process Excellence
   Manager at Comcast and calls Pennsylvania home. At a pr…
   
   Announcement
   Member Spotlight
   Community Champions
   Member Spotlight
   295
   2:10 pm
   6
   


 * THE PARADOX OF GOVERNING USER AUTONOMY
   
   Hello Community, In the world of hybrid work and AI’s promises to transform
   the workplace, IT departments find themselves in the seemingly paradoxical
   position of expanding access to information while…
   
   Announcement
   IT Management
   Show & Tell
   24
   May 8, 2024
   


 * 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 je…
   
   Announcement
   Answered ✓
   Product Announcements
   4675
   May 8, 2024
   76
   


 * COMMUNITY CORNER NEWSLETTER [MAY 2024]
   
   Hello everyone! It’s Arsineh from the Smartsheet Community team. It’s been an
   active month on Community and there’s so much I’m excited to share with you.
   In case you missed it, check out the April Ne…
   
   Announcement
   Community Corner Newsletter
   Community Corner Newsletter
   2190
   May 8, 2024
   7
   


 * 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…
   
   Announcement
   Government
   Smartsheet Gov
   Government
   375
   May 7, 2024
   11
   


 * 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!…
   
   Announcement
   Government
   Smartsheet Gov
   Government
   166
   May 3, 2024
   2
   


 * 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 …
   
   Announcement
   Community Platform
   announcement
   General Announcements
   417
   May 3, 2024
   14
   


 * 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…
   
   Announcement
   badges
   peakhuman
   Show & Tell
   3513
   May 2, 2024
   110
   


 * GET HELP RIGHT AWAY WITH THE PREMIUM SUPPORT PACKAGE
   
   Hi Community, Looking for help with your Smartsheet and want it right away?
   We’ve got you covered. The new Smartsheet Premium Support Package is an
   improved enterprise grade support experience for cus…
   
   Announcement
   Support
   Product Announcements
   120
   May 2, 2024
   6
   


 * CAN ANYONE HELP WITH USING INDEX AND MATCH TO PULL DATA ACROSS FROM OTHER
   SHEETS?
   
   So I tried using the page I have linked below to help me with this but I am
   running into some issues. I have created two testing sheets to use until I
   get the set up right before applying it to my wor…
   
   Answered
   Formulas and Functions
   21
   10:14 pm
   4
   


 * HELP WITH GETTING THE SUM OF MULTIPLE COLUMNS
   
   I am trying to figure out the function to get the sum of multiple columns. I
   also want to be able to apply the function the every row in my sheet. So,
   when the form dumps a new response it auto finds …
   
   Question
   Formulas and Functions
   3
   10:14 pm
   


 * COUNTIFS FORMULA
   
   I would like the below formula to look at the Associate column (external
   sheet) and find Ashley. If it is Ashely then I want it to count if there is
   an issue logged in a four column range (same extern…
   
   Answered
   Formulas
   Formulas and Functions
   82
   10:08 pm
   13
   


 * PARENT DROPDOWNS
   
   It would be amazing if there were a way to edit or add to a parent dropdown
   that can be used and updated across all sheets. This would make more builds
   possible that require many dropdown menus. Many …
   
   functionality
   Idea Submitted
   Smartsheet Product Feedback & Ideas
   4
   10:06 pm
   


 * HOW WOULD I EDIT THIS FORMULA TO ONLY COUNTIFS IN A PARENT ROW?
   
   How would I edit this formula to only COUNTIFS in a PARENT row? I'm not
   looking to add a helper column. Thanks in advance! =COUNTIFS({THD Team Locked
   In}, "1", {Billing Month}, Month@row, {APM}, "Emil…
   
   Answered
   parentrow
   Formulas and Functions
   12
   10:03 pm
   2
   


 * ISO FORMULA TO PULL DATA FROM ONE SMARTSHEET TO ANOTHER
   
   I am trying to pull a site number from one smartsheet to another based on the
   date. So when smartsheet 1 is updated and a site moves to another date,
   smartsheet 2 is updated. Smartsheet1 Smartsheet2 E…
   
   Answered
   Formulas and Functions
   11
   10:02 pm
   1
   


 * HOW TO RUN AN INDEX COLLECT REFERENCING TWO DIFFERENT SHEETS?
   
   Hi everyone, I'm trying to run an Index Collect formula that references two
   different sheets. I want to pull in an email address based on an individual's
   name and position. The formula needs to refere…
   
   Answered
   Formulas and Functions
   9
   10:01 pm
   1
   


 * FORMS AVAILABLE IN WORKSPACES
   
   It would be a great help if Forms were visible in workspaces like they are
   when you make one available offline on the mobile app.
   
   Idea Submitted
   Smartsheet Product Feedback & Ideas
   4
   9:59 pm
   


 * HOW TO DIVIDE SINGLE REQUEST WITH MULTIPLE CONTACTS TO INDIVIDUAL REQUESTS.
   
   Does anyone know how to take a single line, with a single multi-select cell,
   and have that line parse/delineate/divide in to individual lines, either
   through a formula or an automation? Scenario: we a…
   
   Answered
   API and Developers
   functionality
   Dynamic View
   Formulas and Functions
   127
   9:58 pm
   14
   


 * NOT ABLE TO USE SEARCH BAR IN SHEETS
   
   Hello, Our unlicensed users are reporting that they are unable to search
   within a sheet using the search bar. Our Licensed users however are able to
   use this feature without any issues. Both licensed …
   
   Question
   Smartsheet Basics
   4
   9:58 pm
   

 
«1234567…100»
Hey! You will be signed out in 60 seconds due to inactivity. Click here to
continue using the site.

QUICK LINKS


 * Recent Discussions
 * Activity
 * Badge Dashboard
 * My Bookmarks0
 * My Discussions0
 * My Drafts0
 * Trending
 * Unanswered77
 * Groups

CATEGORIES

 * All Categories
 * 14 Welcome to the Community
 * 58.2K Get Help
 * 74 Global Discussions
 * 78 Industry Talk
 * 384 Announcements
 * 11 Community Corner Newsletter
 * 3.6K Ideas & Feature Requests
 * 59 Brandfolder
 * 119 Just for fun
 * 36 Community Job Board
 * 409 Show & Tell
 * 21 Member Spotlight
 * 1 SmartStories
 * 27 Sponsor X
 * 234 Events
 * 7.3K Forum Archives

POPULAR TAGS

 * Formulas 12,302
 * Project Management 4,554
 * Sheets 4,112
 * Reports 2,914
 * Forms 2,707
 * Automations 2,431
 * functionality 2,344
 * IT & Operations 1,769
 * Enhancement Request 1,687
 * Cell linking 1,666
 * Support 1,641
 * Email Notifications 1,590
 * Dashboards 1,527
 * Account and User Management 1,451
 * Conditional Formatting 1,311
 * Integrations 1,298
 * Workflows in Smartsheet 1,114
 * Construction 1,113
 * API and Developers 1,048
 * Sharing and Collaboration 994
 * Update Requests 923
 * Manufacturing 876
 * Gantt View 859
 * Attachments 858
 * Product Development 832

Member Spotlight
"I’ve learned so much from reading discussions and starting my own, seeing
different perspectives. I never would have gotten as far as I have if it weren’t
for the Smartsheet Community!”
Monique_Odom_Comcast, Business Process Excellence Manager

THIS WEEK'S LEADERS

 * 200 Points TamiGross
 * 183 Points PCG Sam Harwart
 * 180 Points Pam L
 * 152 Points Allison.Saettele
 * 134 Points dojones

THIS MONTH'S LEADERS

 * 200 Points TamiGross
 * 184 Points PCG Sam Harwart
 * 180 Points Pam L
 * 152 Points Allison.Saettele
 * 142 Points Paul Newcome

Meet our Community Champions
These are the members who share best practices and lift up others - all right
here on Community.

Learn more