-
Sub-Columns and Grouping by Time on Smartsheet Calendar App
We are a study abroad center and currently use Smartsheet for our class schedule, which works well to combine information between our different sheets. However, when we need to have a more visually effective class schedule (e.g., to verify potential class conflicts, find an empty spot for an event, or simply for…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Hi Everyone, I am Audrey :)
I work as Operations Coordinator at an International Education company in Australia. I have used Smartsheet for a number of years now and slowly became the go-to person for anything Smartsheet at my work. I have attended the Smartsheet summit in June, got the Core Product Badge and am constantly seeking to upgrading my…
-
Smartsheet Template for ADDIE Model of ID
Has anyone created a Smartsheet template that follows the ADDIE (Analysis, Design, Development, Implementation, Evaluation) model of instructional design? I'm looking to use Smartsheet to manage our ID process, which is based on that model. Thanks!
-
Looking for Tips on Building Smartsheet Buy-In
Hi everyone, Our department is still relatively new to Smartsheet, and overall, the rollout has gone well — most team members have been enthusiastic and quick to get on board. We’ve also had a few internal champions who’ve helped drive early adoption, which has been a big help. That said, we’re seeing a bit of hesitation…
-
Efficient Monthly Report Data Collection System for Faculty using Smartsheet
I am looking to create a streamlined system in Smartsheet to collect monthly report data from faculty members efficiently. This would include updates on publications, grants submission, presentations, etc. The main goals include consolidating all of this information in one place, providing a user-friendly interface for…
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
Solution Spotlight: Marketing Management in Higher Education
Hello EDU community! Please join us for an upcoming Solution Spotlight on Marketing and Creative Management designed specifically for higher ed, hosted by our solutions engineering team. Learn how to streamline marketing campaigns with Smartsheet and Brandfolder. The team will dive into how you can consolidate digital…
-
If / and forumula
Hi I'm trying to get a formula that returns the following grades. High Distinction (HD) 85-100 Distinction (D) 75-84 Credit (C) 65-74 Pass (P) 50-64 Fail (F) <50 I've tried this a few different ways but keep getting the #UNPARSEABLE message. Appreciate any help with trying to get this formula to work. =IF(AND(Percentage1 <…
-
Formula Help
I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type]…