Hey guys,

I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning:

1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified


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'm almost certain that there is no solution to this situation, however, here goes.  I have a workspace with approximately 35 project sheets.  Each project has approximately 50 tasks and each has a schedule status in a "Schedule" column.  I want to be able to count these tasks based on their stats