-
Smartsheet engage move forward
Ready for Engage 👏💯
-
Guess what? The podcast episode is now LIVE! 🎙️🔥
Hey Smartsheet Community! Remember that awesome blog post by Luciano Bastos where I got to chat about Smartsheet? We're taking it to the next level with our first podcast!🎙️Diving deep into how Smartsheet makes teamwork a breeze and boosts efficiency like crazy. As I said before, the real magic happens in our amazing…
-
Cross Referencing Data Across Sheets
I've read several threads on this and tried to figure out solutions but am still stumped. I am creating a workspace for managing events. I have vendor lists with their rates and a planning sheet with the number of staff we need and which activities will be booked, etc. I'm trying to create an expense sheet where I can have…
-
Embedding LinkedIn Learning content
It would be great to have the LinkedIn Learning domain on the approved list to be able to embed any of their web content into Dashboards. We utilize that a lot throughout our company for certifications, growth and development, diversity training, etc. Their videos would make great content for our Learning and Development…
-
Smartsheet named to Fast Company's Annual List of Most Innovative Companies 2023 ⚡️
Have you heard the news? Smartsheet was just named to Fast Company's annual list of the Most Innovative Companies 2023 in the Enterprise category! We were recognized for creating a unified digital workplace, allowing users to drive meaningful change. They specifically called out DataTable, Brandfolder, and Outfit. 🎉 Read…
-
Upcoming Smartsheet Q&A Webinar including Me!
I'm excited to announce that I was invited to take part in a Smartsheet Q&A webinar, and I will be one of the panelist answering questions! Date: 09-March-2023 Time: 1:00 PM EST (GMT-5) If you are interested, here is the signup link: tinyurl.com/pwsmartsheet
-
COUNTIFS with multiple IS NOT statements
Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operation. I can't figure out what I'm missing in the formula. Here's the formula that works:…
-
Free Webinar: Collaborate on Content with Proofing
Join us January 27th for our webinar "Collaborate on Content with Proofing." On this webinar you will learn how your team can review and approve content with Smartsheet Proofing. We will be hosting 3 sessions across multiple timezones, if you are not able to join us live, feel free to still register and we will share the…
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…
-
Multiple Sheets & Formula Updates
I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when…
-
Dynamic Data Validation with Columns from another Grid
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that serves as tracking tasks related to the projects in the master sheet. When People…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Calendar View & Booking
Hi - our company is looking to hire out a hospitality box in London for a 12-month period that hosts events all year round. We would like internal employees to be able to view the event calendar and to book slots for a specific date where they can then invite their own external customers as well as internal guests. In…
-
Integrate with Microsoft Access
Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
-
Document Management Systems
Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their implementations. (how well it integrates with SS, potential problems). It doesn't have…
-
Priorities within Priority
I have my priorities set up for high, medium, low. I'd like to prioritize within the highs, lows, etc. I'm used to working of an ABC, 123 set up.
-
FIRST OF THE MONTH AFTER 60 DAYS
I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date) I need to have the following result as an example Start date: 1/15/2020 Effective Date: 4/1/2020 Thanks!
-
Conversations — but with groups?
My org used to use the “Send” or “Send Update Request” option from the fly-out menu on each row quite frequently. That feature is now only available to licensed users, I believe, as Smartsheet moves people to use conversations in the comments instead. See:…