Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized.…
I have a sheet where we are tracking comments from various agencies. Each agency lists their comments as children under a parent row of the agency name. A separate checkbox column indicates whether th…
I want to count the number of items when their description contains a certain word. Count if Description contains the word "grey". There would be multiple descriptions with the word GREY in the column…
Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencin…
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using f…
I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.
I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value. If the value in column1 is 1 and column2 is VendorX then sum all values in column3 co…
Hi I've searched the community and can't seem to find an answer for this one. I have a column with project roles and the hours for each role required for individual tasks. I would like to summarize th…
I've got 4 rows of data (and there will eventually be more). I'm trying to add up one column (Duration (in quarter hour increments)) IF another column (Program Bug) shows NO check in the checkbox fiel…
