Hello, Trying to create a formula that can substitute the plan date with actual date. There are columns of Plan Start/End, Actual Start/End on the sheet, and the actual start & end are initially left …
Hi, Looking to calculate the number of netdays since an event was recorded. I have a {Date of Incident} column and a {Classification} column Looking for the number of days since a specific classificat…
Trying to summarize from a worksheet to another (summary worksheet). The VLOOKUP should give an "X" if includes "August" and instead gives the same answer for every search since there are multiple of …
Hi, i am looking for some help. I have a project which has 360 locations, resulting in 360 rows. i have 8 status columns in each row. is there a formula that will replicate a % by counting each status…
I've got a pretty simple requirement which I'm struggling with. I have a dropdown defined with % values for completion (ie 100%, 75%, 50% etc) and I want to create a formula which searches for complet…
Hello, I have been trying to work this one out. Attached is a picture of the column that i wish to tally. This column is a checkbox column and there are multiple parent lines (these are the colours li…
Hi All, image different questions (1 for each column) with 3 possible drop-down answers (Yes, Maybe, Not). Every combination question/answer generate a different score. Ex: Question 1 * Y - 3 points *…
I have a hierarchy of checkboxes. I am trying create a IF(AND) formula to at the Level 1 checkbox to be checked once all the Level 2 boxes are checked. I am able to make it work when I reference each …
I'm trying to create an IF statement that relies on the data in 2 cells. Basically, if one cell is checked off and the other is empty, I want to create a formula on a new cell (which I will hide) so I…
I'm trying to create a formula that will automate the RYG balls (red, yellow, green) based on the project's % Complete. Green = 100% Yellow = 50-99% Red is = 0-50% Below is how I wrote the formula, bu…
