Hi all 

I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget

The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the



I have a particular situation: 4 columns defined as checkbox. The description of the columns reflect a sequence: Open, In progress, Pending and Closed. I need that when I tick a subsequent columns/status the previous one (or the others) will be automatically unticked.

Could you please help