-
IF function in column formula not working
Hi Community, I have an IF function that I have working on a row but if it try and copy the formula into row below or convert to a column formula it does not work and gives #unparable. Formula is below. Am I missing something obvious? =((IF([FAS Time]@row > 0, "FAS, ")) + (IF([FSE Time]@row > 0, "FSE, ")) + (IF([Cust Care…
-
How to count number of Past Due Tasks
I use the formula below to track my past due tasks : but it is not giving me the correct number currently my sheet does not have any late task according to my filter below : Which formula should I use to make it possible ?
-
How to Track Someone's Past due Task
Hi, I have tried to write down a formula at the sheet summary that tracks the number of past due tasks assigned to a specific person on my sheet but it is giving a #UNPARSEABLE error below is how I have done it : =COUNTIFS([Is Past Due?]:[Is Past Due?], "Yes", Status:Status, "In Progress", [Assigned To]:[Assigned To],…
-
How to count the number of Flagged rows
Hi, I'm trying to count the number of rows on my sheet summary that are flagged on my sheet it seems my formula is not working it gives #INVALID DATA TYPE error Below is the formula : =COUNTIF(TBD:TBD, @cell) The name of the column is TBD as seen on the screenshot below :
-
How can I count a range of dates based of a condition?
I'm trying to keep a tally of how many cancelled dates per month for each state/country and I can't quite figure out the formula to make it work. Can someone please help me?
-
Seeking a formula that counts specific characters in a cell.
My project task sheet has parent rows for each department and child row for each project within the parent department. Each project row has a LEAD DEPT column with dropdown options that show the department acronym and business unit---DEPARTMENT (Unit). The LEAD DEPT options are; DCM (Marketing) DCM (Membership) DCM…
-
Weekly Comparison
Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be updated with previous week's percentage without the manual labor (think of 300+ rows). Is…
-
Can somebody help trying to read only data from this Month
Hi My plan is to bring data from the current month, from a different sheet using cross sheets formulas. My code below is not working any idea why? It says #UNPARSEABLE Any help is much appreciated =SUMIF({Actual Completion Date}@row)=MONTH(TODAY()),({Completed Jobs Value})
-
Auto Label Parent Rows
Hello! I'm looking for ways to automate labeling the parent rows for an onboarding sheet. I want to automate the label of the day so that I won't have to manually adjust it every time. Here's a sample a screenshot:
-
How can i use symbols of 4 different colors for the following scenarios?
could you help me please? There are 2 parts; part 1; contract notice period, part 2; contract expiry time for part1; If the day remaining until the notice of termination is over 60 days; Green If it is between 60 - 15 days; blue If between 15 and the termination notice period; Yellow If the notice period for termination…