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 the comment is resolved. I am trying to create a formula to calculate the number of unresolved comments per agency in each…
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. Ex. Dark Grey, Grey Mist, Green Grey, Blue Grey. I want a total for all items that are GREY. Is this possible? Other…
Hi! I am trying to edit the three cross-sheet references in all the columns from the master sheet of 2018 to master sheet of 2019. Since I need to repeat it for almost 1200 cells. Is there a way to bulk edit like Find and Replace or something else? Even for selected cells will make it so much easier! the original is :…
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 referencing each cell in a range. Example: Project1 will start in 2018, which is reflected on sheet 2. formula in column 2 row 2 on…
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 for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…
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 corresponding to the conditions. I am not sure if the SUMIF will work for this.
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 the total hours for each role Currently I am creating hidden columns for each role and to determine the role hours for each…
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 field. I put this formula together, but clearly I'm doing something wrong: =if([Program Bug]4:[Program Bug]7=0,SUM([Duration (in…
I doubt this is possible but thought I'd ask anyway. I want to know if there's a way to indent a row with a formula. So if a user submits a form and indicates that it should be a child row of a specified parent row, would it be possible to have a formula in place that indents that row when certain conditions are met?…
