-
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]…
-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo