Education
Discussion List
-
Free Webinar: Intro to Data ShuttleIn Apps, Integrations, and Add OnsJoin us on September 16 for our webinar Intro to Data Shuttle where we will be discussing how we can leverage Data Shuttle to automatically and seamlessly upload or offload data between Smartsheet and other tools you use.
-
Averageif and match for summary of infoIn Formulas and FunctionsI'm trying to average the the percent of submissions for an assignment on one Smartsheet based on a teachers ID in the current sheet. Here's the formula I've tried =AVERAGEIF({Quiz 1 Completion Avg}, MATCH([email protected], {ID })) The results tha…Answered - Pending Review 37 views 11 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Return unique values while ignoring blanks.In Formulas and FunctionsHello! I'm trying to find a function similar to vlookup or index that will return a unique value where there are duplicate search values. In this example, individuals book a desk on a given date. Since form submissions create a new row, th…
-
Return status of cell (blank vs. full) at today's date.In Formulas and FunctionsHello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS da…
-
Free Webinars: Smartsheet AdvanceIn Using SmartsheetJoin us for our upcoming webinar series where we’ll be introducing how Smartsheet Advance enables you to scale existing work, build more advanced solutions, and connect your Smartsheet work to other systems and platforms. We will be kickin…
-
Automatically Track Inventory UsageIn Formulas and FunctionsI'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage base…
-
Looking for Smartsheet cheat sheets and/or packaged training materialIn Using SmartsheetHi, I am the project manager across a number of projects and we are onboarding users to Smartsheet so that they can use what templates that we have developed. In some cases, this is senior leadership who just want to have the basics, all t…
-
Tracking Employee Training and CertificationsIn Using SmartsheetHello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share? TiA!
-
Feature request: ability to edit and link to sheet cells from a DashboardIn Using SmartsheetHi! Following up on this feature request, we would also like to request the ability to edit cells from a Dashboard and well as linking to them. Our use case is simple: our team uses dashboards for individual task and team management, and…