Announcements
-
June Question of the Month - Join the conversation and receive a badge
There are so many amazing members in the Smartsheet Community (just in the last 12 months, 33k new ones joined!), and each of you has a unique story about how you discovered it. Thank you so much for sharing those stories on May’s Question of the Month. Be that you joined years ago, or in the last few days, were introduced…
-
[NEW] Welcome to the Webinars Topic!
Hi Community, If you love learning about all things Smartsheet, our newest addition will be a real treat for you. Introducing the Webinars topic — a place where you can find live, and on-demand webinars about best practices, feature releases, product specific deep dives, and more! Excited? We’ve got one more surprise for…
-
Certification Discount - Get certified this June & July!
Hi Community, If getting certified is one of your goals for 2024, we’ve got great news for you! This June and July, showcase your Smartsheet expertise by getting certified. We’re discounting the Core Product, Project Management, and System Administrator certifications — use code certification_success_24, to register for…
-
Introducing the PeerConnect Program!
Hey Smartsheet Community, We love how much you help each other, and the many friendships that have been born in the Community. Having peers by your side, and knowing someone else is in, or has been on a similar journey can be very validating and empowering. That’s why we’ve created PeerConnect. This is an opt-in program…
-
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…
Recent Discussions
-
Smartsheet Limit Viewers
I currently have a ticket system setup in Smartsheets using certain conditions that will alert the requestor once the task has been completed. I want to be able to have the requestor comment on their submission within the form without seeing everyone else information. Is this possible? If so how?
-
Clinical Trial Identification Tool
I created a form where providers can enter medical history to determine if a patient may be potentially eligible for a clinical trial. The sheet containing the form submissions has columns with cross-sheet formulas that match the patient's history to clinical trial eligibility criteria listed in another sheet. This is…
-
How to share filters?
Can someone explain to me how to share a filter with another person viewing the sheet? Thanks
-
Multi-Tier Control Center: Onboarding New Employees
Hi, I am hoping someone might have an idea on how I might approach using Multi-Tier Control Center for onboarding new employees for a business with multiple departments. Currently, I have normal Control Center with a blue print and intake sheet, so I can create a new project/onboarding folder for new employees in a single…
-
Data Over Time Report/Dashboard
Hi. I'm currently developing a dashboard to analyze metrics derived from support ticket submissions. I've been asked to provide insights into peak ticket hours, and I need assistance in generating the corresponding report/chart. Is it possible to use a "created" column from one sheet to generate a chart highlighting the…
Newest Questions
-
Clinical Trial Identification Tool
I created a form where providers can enter medical history to determine if a patient may be potentially eligible for a clinical trial. The sheet containing the form submissions has columns with cross-sheet formulas that match the patient's history to clinical trial eligibility criteria listed in another sheet. This is…
-
Multi-Tier Control Center: Onboarding New Employees
Hi, I am hoping someone might have an idea on how I might approach using Multi-Tier Control Center for onboarding new employees for a business with multiple departments. Currently, I have normal Control Center with a blue print and intake sheet, so I can create a new project/onboarding folder for new employees in a single…
-
Using Reference Sheet to toggle Checkbox
Hello, I've been digging and digging through Smartsheet posts and other references and cannot seem to find a comparable reference to use for my use case. I have 2 sheets. The first sheet stores PMs for equipment inspections. There is a column for "Equipment Name" and a column "PM Date". The second sheet has a column for…
-
How do I pull in a pay rate from another sheet when the identifier is on the sheet multiple times
Trying to Index/Match - Help! I need to pull the 'Total Base Pay - Amount' from another sheet into my current sheet by using employee ID as the match identifier, however there are 3 of the same employee ID on my current sheet. I am guessing since there are 3 of the same employee id's on my first sheet, it's confusing…
-
Prefill Contact Field using URL query
Hello, I've tried every trick and formatting option possible to prefill the contact field on a form using the contact field from another sheet. The contact list looks like the screenshot below. The true field name in the sheet of Product Line Manager is PLM I've tried ?PLM=Kevin%20Hietpas%20%28khietpas%40email.com%29…
Explore. Ask. Answer.
Discussion List
-
June Question of the Month - Join the conversation and receive a badge
There are so many amazing members in the Smartsheet Community (just in the last 12 months, 33k new ones joined!), and each of you has a unique story about how you discovered it. Thank you so much for sharing those stories on May’s Question of the Month. Be that you joined years ago, or in the last few days, were introduced…
-
[NEW] Welcome to the Webinars Topic!
Hi Community, If you love learning about all things Smartsheet, our newest addition will be a real treat for you. Introducing the Webinars topic — a place where you can find live, and on-demand webinars about best practices, feature releases, product specific deep dives, and more! Excited? We’ve got one more surprise for…
-
Certification Discount - Get certified this June & July!
Hi Community, If getting certified is one of your goals for 2024, we’ve got great news for you! This June and July, showcase your Smartsheet expertise by getting certified. We’re discounting the Core Product, Project Management, and System Administrator certifications — use code certification_success_24, to register for…
-
Introducing the PeerConnect Program!
Hey Smartsheet Community, We love how much you help each other, and the many friendships that have been born in the Community. Having peers by your side, and knowing someone else is in, or has been on a similar journey can be very validating and empowering. That’s why we’ve created PeerConnect. This is an opt-in program…
-
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…
-
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…
-
Changes to asset Admin permissions and new Plan Asset Admin role, now generally available!
Update on 03/25/2024: Phase 1 of the asset ownership changes is now available for all customers. Hi Community, Currently, core Smartsheet assets (such as sheets, reports, forms, and dashboards) are owned by individuals in a plan. However, the current ownership model can create friction when key stakeholders or asset owners…
-
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…
-
Introducing our new video series - SmartStories!
Hi there Community, Did you participate in our Question of the Month back in November? So many of you shared the Smartsheet features you were thankful for, and we LOVED your responses. We liked them so much, that we decided to prepare something special to showcase a few: Big shout out to the very cool members featured on…
-
Community Corner Newsletter [June 2024]
Hello hello Neighbors! This is Marcela from the Community Team. Welcome to another edition of our Community Corner Newsletter! First, a big thank you to Arsineh for presenting an amazing edition last month, and sharing some wonderful pictures of the Solar Eclipse. If you missed it, you can check out all the interesting and…
-
Smartsheet Limit Viewers
I currently have a ticket system setup in Smartsheets using certain conditions that will alert the requestor once the task has been completed. I want to be able to have the requestor comment on their submission within the form without seeing everyone else information. Is this possible? If so how?
-
Clinical Trial Identification Tool
I created a form where providers can enter medical history to determine if a patient may be potentially eligible for a clinical trial. The sheet containing the form submissions has columns with cross-sheet formulas that match the patient's history to clinical trial eligibility criteria listed in another sheet. This is…
-
How to share filters?
Can someone explain to me how to share a filter with another person viewing the sheet? Thanks
-
Multi-Tier Control Center: Onboarding New Employees
Hi, I am hoping someone might have an idea on how I might approach using Multi-Tier Control Center for onboarding new employees for a business with multiple departments. Currently, I have normal Control Center with a blue print and intake sheet, so I can create a new project/onboarding folder for new employees in a single…
-
Data Over Time Report/Dashboard
Hi. I'm currently developing a dashboard to analyze metrics derived from support ticket submissions. I've been asked to provide insights into peak ticket hours, and I need assistance in generating the corresponding report/chart. Is it possible to use a "created" column from one sheet to generate a chart highlighting the…
-
Converting Text to Date
Hi there community! I have a column with session dates and times that form users are selecting from (dropdown) but I need to turn it into a date so I can trigger a reminder of upcoming sessions. I used the following formula to remove the time and add the year, in the [Date 2] column, and it is working to display just the…
-
Dashboard canvas size conversion
(Sys Admin) Custom welcome, help and upgrade screens are set to a 970 pixel width. I have created my custom screens as dashboards because that just seemed to make sense. I want to set my welcome screens in the dashboard to 970 pixels wide - is there any way I can do this? eg can I convert the squares in the dashboard…
-
Using Reference Sheet to toggle Checkbox
Hello, I've been digging and digging through Smartsheet posts and other references and cannot seem to find a comparable reference to use for my use case. I have 2 sheets. The first sheet stores PMs for equipment inspections. There is a column for "Equipment Name" and a column "PM Date". The second sheet has a column for…
-
Sheet Summary Report - Multiple Instances of the Same Fields
I have created a template for our PMO to use and a report based on the sheet summaries each sheet contains. Older projects have had the sheet summary fields added, rather than migrating existing projects to a new sheet based on the template. Something odd is happening - some fields are appearing twice in the column…
-
Parsing full name using =Left
The following gives me Mike in the column =LEFT(Update@row, FIND(", "Update@row) - 1), but I want Mike Smith in the column, but I can’t see how to capture the full name using spaces from the following row: Update Row: Mike Smith entered geo-fence Mt View Road
Categories
Member Spotlight
“I’m extremely proud to be a Community Champion and of the Community in general. Everyone has one of those tricky builds you just can’t solve on your own. Being able to help someone get that working is rewarding, especially as I’ve been on the other side of needing help from the Community.”
This Week's Leaders
This Month's Leaders
Popular Tags
- Formulas 12,471
- Project Management 4,589
- Sheets 4,156
- Reports 2,964
- Forms 2,756
- Automations 2,512
- functionality 2,378
- IT & Operations 1,772
- Enhancement Request 1,703
- Cell linking 1,689
- Support 1,649
- Email Notifications 1,604
- Dashboards 1,575
- Account and User Management 1,463
- Conditional Formatting 1,324
- Integrations 1,300
- Workflows in Smartsheet 1,144
- Construction 1,113
- API and Developers 1,083
- Sharing and Collaboration 1,008
- Update Requests 938
- Manufacturing 877
- Attachments 874
- Gantt View 867
- Product Development 843