Bradhickswa✭✭

@Brent Wilson Thank you for your input and describing your process to me. I've implemented the COUNTIF formula as you laid out in my sheet and while it does show the number of times a specific "task" shows up in the task column, I'm more concerned with determining if the same task being done locally and for overseas is…

梳子@Andree Stara我创建报告ining the two sheets, however, there are some repetitive tasks for each location that need organization. Also, it looks like the report didn't carry over the predecessors from the original sheets. I also assigned tasks to individuals which didn't carry over either. -Brad

Hi @Andrée Starå , I did think of combining the two sheets into one report, which would be fine for viewing on a Calendar, but we have technicians that rely on the sheet to "check off" tasks as they complete them. I also have it set up where they can switch to Card View and keep track of all the tasks assigned to them. Is…

My scavenger hunt is complete and I am ready to obtain my badge (and swag) to show for it! :-)

I second this idea!

I second this idea! I have various projects that I use Smartsheet to help manage and being able to color coordinate the sheets would be extremely helpful in distinguishing the projects from one another.