-
Can a copy of form responses automatically be sent to multiple emails after a user completes survey?
Hello, I work in medical education and am looking for a way to have the results of a filled form automatically sent to multiple emails. Essentially the problem I am attempting to solve is this: We are looking to have medical students receive instant feedback from their faculty supervisors through Smartsheet. Ideally,…
-
Remove Primary Column From Report
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
-
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…
-
For profit education space - any others out there?
Hi there - I work for a for-profit company that runs schools, delivering classes and programs in various industries. This puts me in an interesting cross-section of education. Wondering if there are any others out there in a similar situation and how you've found Smartsheet to be most useful in some of your most common…
-
Educational Publications
Hey Everyone, My name is Brandon Good and I work at ETS where we develope assessments and publications for education. My group has been using smartsheet for four years now to manage and track the production of all our products we deliver to our clients. We are currently looking into how to utilize Data Shuttle and the…
-
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!
-
Template for Tracking Admissions Data
Hello SmartSheet! I am trying to decide which template to utilize for my admissions data needs. There will be 200-300 students total, and I need to assign them between 5 reviewers. They need to be able to score the student 1-4, leave comments, and mark when their evaluation is complete. How might I organize all this data…
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
Count formulae
Hi all, Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations: To calculate the count of 'Medical Device Related' category from the 'Relevant System' column Same as the above but for 'Non-Medical Related' category I want to have a breakdown of the sub-categories for each…
-
CONTAINS to count cells with specific string of numbers
Is there a way to use COUNTIFS and CONTAINS to count cells that include a specific string of numbers as well as cells that include that string plus something else? In the example below, I'm trying to count the number of students who are taking the course with the Code "20659," which should include those taking only that…
