-
Counting and Averaging with Exclusions
Hello Smartsheet Community, My organization uses Smartsheet to track our recruiting efforts. Each of our divisions has its own sheet, and we have a metrics sheet to tie all of the divisional sheets together. I am having issues both at the divisional sheet-level and the metrics sheet-level. Problem 1) Sheet Summary…
-
Determining Exact Match for Multiple Criteria in a Multiple Selection Dropdown
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:…
-
Triggering a Microsoft Flow when a column is updated
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…
-
Set up automated workflow to copy child rows to another sheet?
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?
-
Webinar recording: Dashboards introduction and best practices
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…
-
Higher Education Campus Reopening Webinar: July 15 (10:00am PST, 1:00pm EST)
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"…
-
How are you returning to campus in the Fall?
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!
-
Hierarchy Formula
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…
-
Is there a way to change info in a master sheet to be reflected in sub sheets?
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…
