In Sheet 1, a user enters a course code (e.g., BUS 123) in one column. Smartsheet searches for that code in Sheet 2, finds the corresponding program leader's name and e-mail address, then puts them in two cells in Sheet 1.
Now Sheet 1 shows the course code in Column 2, the program leader's name is
I am using Conditional Formatting to change the background color of a row based on the value of a cell in that row. I want to visually distinguish courses on a course development list belonging to certain colleges.
I am relatively new to using Smartsheet, but here is what I'd like to be able to do.
I have a Course Development Tracker sheet that lists courses to be developed in the next term. My team has a 60 day development process, with 5 checkpoints. Each checkpoint should be met by a certain number of days
I am creating a summary sheet and would like to include a sum of course developments by college. I know how to do a SUMIF in general, but can I use the CHILDREN function to sum (or count the number of instances) of courses/payments based on the value in the College column?