I'm trying to show health of a project based on how far out from End date + how much of the work has been completed. Green: 100% complete before or on End date Yellow 70-99% and today is < 1 range of …
I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!
I have two columns, "Assigned To" and "Date Entered". What I want is to count blank "Date Entered" cells that are assigned to a specific person. Is this possible?
Hi, I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs shee…
Hi! I'm managing a retrofit project and the end goal is to create an executive dashboard highlighting key metrics in the form of charts and/or graphs. From what I've found via searches, it seems like …
Hello, I've developed a sheet that our Project Manager use to generate a Certificate based on a number of criteria. So the Certifcate (a dashboard) pulls the correct data from multiple sources, the us…
We have a form we would like to send to employees every morning, then be able to track each response separately. Tried automating the sending out of the form but when employees respond it overwrites t…
Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones…
I'm working on developing a template workspace for our PM to use, that will eventually roll up to a PMO workspace. We plan on getting licenses for the PM if we go to production after the pilot. Each P…