-
Trying to find value text
I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @cell, "Q2_2020" @cell, "Q3_2020" @cell, "Q4_2020" @cell, false)" What I'm looking for is to find the triggering…
-
Helper columns vs #UNPARSEABLE error
This works for me using helper columns where I do count(parent) and count(children) =IF(OR(children18 = 0, Parent18 > 0), 1, 0) If I substitute the count(children) its #UNPARSEABLE =IF(OR(count(children) = 0, Parent18 > 0), 1, 0)
-
Time-tracker formula
Hello, I have a time-tracker and have 2 problems: For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours1 When I remove the first entry which was a test, it messes up the calculation on the ones…
-
How do I set up a 'running date column'?
Similarly to a running total, I am needing to have a running date. So that every day it will move and change based on 'today'-- and referencing my start date column. How do I set this up?
-
Formula Using IFS, Contains, and AND
I am trying to troubleshoot the following formula: =IFS((CONTAINS("Shadow", {GI Clinic 3 Session})), AND([Provider Last Name]3), "Scheduled") Logic: If the cross-referenced sheet (GI Clinic 3 Session) contains the word "Shadow" and the Provider Last Name is the name in cell 3 (current sheet), then say "Scheduled."…
-
Using dates without a date column.
Hi, Is there a way to use dates in formulas without them being in a date column? I am trying to reference a drop-down column that has some dates in it and then take 42 days off of them. Is there a way to do this without the dates being in a date column as it needs to be a drop-down column. Thanks, Liam
-
If(And(Or
I'm trying to create a formula that includes If, And, and Or in it and I'm having trouble figuring out the correct way to write it. Written out what I need is: If "restrictions in place through" is greater than 3/28/2020 OR equals UFN AND "max # of people.." is greater than 0 make "local ordinance status" yellow and If…
-
Changing the colours assigned to various groups in the Calender App
Hello, I want each name to have a different colour in the Calender App. I can select "Color by Column" and it works but I find the automatically chosen colours to be garish and I would like to set my own. However, the option to change the colour does not appear on the right (see picture) I have another column where this…
-
Help With Adding More Conditions in Current IF Formula
Hi everyone, I am currently struggling to add more conditions to my current formula. The formula is: =IF('Department 1'[Approval Response]="Pending" && 'Department 1'[Past Due/Scheduled]="Past Due",1,0) I want to add two more conditions to the approval response: "In Process" and "On Hold", while keeping the second half of…
-
Date formula returning "#INVALID DATA TYPE"
Hi guys, I can't figure out what's happening here, hoping someone can point me in the right direction Importing a table with a "Date" column set as primary column, Date format is YYYY-MM-DD Trying to convert the value into a format I can use by splitting the date string into it's seperate components using MID function, and…