I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed


I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month:

=COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY()))


Then I


While the header of my question seems confusing, hopefully an easy solution exists somewhere.

I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to a sheet ("sheetX" for later reference).

What I want to do is try