-
substitute plan date with actual date
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 blank, and once a task is kicked off, the one assigned is supposed to fill in the actual start, which substitutes the…
-
Number of NetDays since last event
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 classification was reported i.e. {Classification}, ="Lost Time Injury". Want to be able to report this as a Key Indicator of No. Days…
-
IF and VLOOKUP with multiple options
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 the original search; it's saying yes since it saw it the first time, but shouldn't if actually missing. Original worksheet…
-
% complete in a row
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 column that is complete and making that =12.5 . So for example all 8 status are complete this = 100, 6 status complete…
-
Matching a percentage dropdown entry
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 completed tasks (ie any cell with 100%). I imagine this is pretty common. However, the cell type doesn't seem to be textual, nor…
-
Formula help
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 lines) The top line is the grandparent line the white rows are the children. So what you see is each children row has some…
-
SUM more results from more IF conditions
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 * M - 5 points * N - 8 points I need to have in a single cell the sum of the score of a gruop of question. Have you any tips…
-
If(AND) across a range
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 of the cells , for example: =IF(AND([Map Complete]18= 1, [Map Complete]19 = 1, [Map Complete]20 = 1), 1, 0). When I do it…
-
Unparseable Error in IF(And formula
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 can ultimately send an update request to the user to fill in the notes field. I haven't used the AND formula nor have I…
-
RYG formula based on % Complete
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, but I'm getting a Unparseable errors. **Note, I'm trying to enter the formula into the Status column on row #5, figuring I…
