I am trying to grade a quiz where the answers were submitted via a smartsheet form. I am having trouble figuring out how to confirm that there is an exact match on questions that had multiple answers needing to be selected to be considered correct. On questions that only use one answer, this is the formula I use:…
Hi all, I have a smartsheet that my operations team manages. It tracks all orders that we receive through our defined shipping process. Each order is a new row and there are multiple columns. One of them is the "Estimated Shipping Date" which someone from our team will fill out. I want to create a Microsoft Flow that…
I have a sheet set up with parent rows for each month. I want to copy the child rows underneath the "July" parent row to another sheet using an automated workflow. What condition do I set if I want the rows under "July" to copy to the other sheet on the first of every month?
Missed the webinar? Review the recording in the Learning Center. Join us for a two-part webinar series focused on Smartsheet dashboards. Introduction to Dashboards Learn how to build a visual Smartsheet dashboard to provide a robust, real-time view into data from your sheets and reports. Dashboard design best practices…
This one-hour session is free to join and features a review of our new template set on Return-to-Campus Planning, customer insight on how they use Smartsheet, a short dashboard demo from our Sr. Global trainer, and ending with an open forum to discuss your own use case or ask questions. Check out the "Upcoming Events"…
Let us know what your school's plans are for returning to campus in the Fall! Smartsheet is dedicated to helping you in this process. Request access to our Higher Ed Back To Campus Planning Tool to learn more!
Hello! I've been trying to count how many milestones called "Testing" with %Complete = 100% are per project. Each milestone is a child of a parent called "Milestone" and this is at the same time a child of the project name. At the end, each project is a child of a big project name. (I've attached an example of the…
Hi all! New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work…
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
