-
Overall Total % completed
Sorry If this is a repeat but the first post seemed to have disappeared. My Goal is to have the Top row #1 Where that checkbox is to say what the total of completed of all the subtaks below. For example the Level 4 is showing 100% completed so the Top row should show 25% completed. But Not sure how to accomplish this? Each…
-
INVALID DATA Type when using countifs formula referencing from another sheet
Hi, I am computing for weekly counts of leads generated for my report and I am using countifs formula and refer to the working sheet where my data is located. I am pretty sure that I am referencing in the correct Date Column and it's data type is also a Date. But the formula is prompting an "Invalid data type error". When…
-
Can anybody correct my below if condition ? I need that asap
=IF(OR(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",[DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)"), "FILLING"), IF(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)", [DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",OR([Priority]10 = "HIGH","MEDIUM")), "QUICK…
-
Flag columns and formulas?
Hi, I would like to use a Flag column with the following workflow: Manually enable the flag. Automation then sends an approval request once date is reached (in separate column). I would then like to have the flag clear when the "Approval Request" column gets an "Approved" response back from the automated approval request.…
-
Why is my COUNTIFS formula counting more items than necessary?
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desired amount of days") The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns…
-
Remove Extra Commas in Join/Collect?
I have a great formula of JOIN and COLLECT together that pulls info from 11 columns. It pulls strings if they meet certain conditions with commas as a delimiter. But if the conditions are not met, I have a bunch of commas next to each other. E.g. , , , EX1, , EX4, , , , and in some cases, just 11 commas. Is there a way to…
-
IF-formula on a date range
Hi guys, For the last couple of days I've been trying to create a simple formula, but in some way it doesn't work. I want to check if the date of today falls inbetween a specific date range (2 different columns), using the IF-formula. I've tried this formulas: =IF(AND([Date 1]1>=TODAY(),[Date 2]1<=TODAY), "True", "False")…
-
Counting Multiple Location Values
I have a metric sheet and I'm currently using a CountIF formula to count the locations in my sheet, works great. But I'd like to take it a step further and I want to group the location entries into APAC, NA, Canada, & EMEA. I'm trying to use this formula: =COUNTIF({ERG MEMBERSHIP EA Location}, "Hyderabad, India",…
-
Gantt - Progress Ahead or Behind Schedule?
Hi All I'm keen to look into options to report on project progress against schedule. Generally we set a project programme, then progressively update %Complete against lines and the project progresses. The progress bar works well as visually indicating if each activity is ahead or behind the current date. I'm looking to try…
-
Is it possible to have a column in a sheet serve as a reference to multiple other sheets?
Here is my scenario: I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some of the new sheets use the same data and formulas. Copy and pasting the formulas sometimes required me to recreate the…