or Explore Discussions

# Education

## Discussion List

• Free Webinar: Intro to Data Shuttle
In Apps, Integrations, and Add Ons
Join 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.
148 1
148 views 1 comment Most recent by Victor Agudelo Apps, Integrations, and Add Ons
• Averageif and match for summary of info
In Formulas and Functions
I'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…
37 11
Answered - Pending Review 37 views 11 comments Most recent by Paul Newcome Formulas and Functions
• Return unique values while ignoring blanks.
In Formulas and Functions
Hello! 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…
Accepted
166 5
Answered ✓ 166 views 5 comments Most recent by Paul Newcome Formulas and Functions
• Return status of cell (blank vs. full) at today's date.
In Formulas and Functions
Hello! 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…
Accepted
13 2
Answered ✓ 13 views 2 comments Most recent by Clayton Richards Formulas and Functions
In Using Smartsheet
Join 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…
190 1
190 views 1 comment Most recent by Sandra Guzman Using Smartsheet
• Automatically Track Inventory Usage
In Formulas and Functions
I'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…
689 7
689 views 7 comments Most recent by Alexander Coales Formulas and Functions
• Looking for Smartsheet cheat sheets and/or packaged training material
In Using Smartsheet
Hi, 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…
143 1
Answered - Pending Review 143 views 1 comment Most recent by Paul Newcome Using Smartsheet
• Tracking Employee Training and Certifications
In Using Smartsheet
Hello! 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!
Accepted
1402 4
Answered ✓ 1.4K views 4 comments Most recent by Andrée Starå Using Smartsheet
• Feature request: ability to edit and link to sheet cells from a Dashboard
In Using Smartsheet
Hi! 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…
657 14
657 views 14 comments Most recent by Andrew Stills Using Smartsheet