-
Check Flag with formula
I am trying to turn on a flag with a formula. I am using the below, my problem is that the flag does not turn red, when I enter the formula the flag disappears and I get a 1. When I take the flag formatting off and change it to text I get "true" and then turn the flags back on I get my red flags, but then I try it again in…
-
RYGB X Checkbox question
Hello again Community! I currently use the following formula for our projects: (Works well!) =IF(Finish15 <> 1; IF(due_date15 - planned_date15 > 0; "Red"; IF(due_date15 - planned_date15 > -3; "Yellow"; "Green"))) But now I would like to include a blue ball when the "finish" checkbox is checked. I tried some alternatives,…
-
How to reference the <CELL ABOVE>
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…
-
Invalid data type result when joining a complex collection
I'm receiving an "#INVALID DATA TYPE" result with the following forumla: =JOIN(COLLECT({LocationStrings}, {LocationStrings}, NOT(ISBLANK(@cell)), {PersonNames}, @cell = $[Person contact list]29, {ProjectStatus}, OR(@cell = $Status$5, @cell = $Status$6), {DeliveryDate}, AND(MONTH(@cell) = MONTH(TODAY()), YEAR(@cell) =…
-
Display last value in column
Hello Community! My question is quite simple. (I hope). How can I display the last value of a column? I tried to use the formula = INDEX, but I could not read the last number automatically. Thanks!
-
Help on formula: Countifs with multiple columns and criteria
Hi, So I've been working on a formula but couldn't get it right. I wanted to count the number of my projects that are Active (on-time) and Active (delayed). I get the on-time count correctly but for the delayed ones I always get a plus 1 in the results. Here's the formula I use (btw the stages represents that a project is…
-
count if check box is not checked (2) and requested date is within a date range
I am trying to get a count of each row on my sheet that meets the following criteria. Children of ([Requested Date]17) (which is date format column) is between 1/1/18 - 1/31/18 and Children of (Canceled17) (which is check box format) is not checked (0) and Children of ([Not Owner]17) (which is a check box format) is not…
-
Nested IF and Forms
Good morning. I created a meeting request form for business units to fill out so we can capture information we need about an upcoming conference. I'm trying to rig the way the information is captured on the sheet and am having a little trouble with the Nested IF. I have columns for each meeting date and a drop-down option…
-
Referencing a predecessor in formula
Hi, I would like to change a symbol cell based on the status of a predecessor completion status i.e. "If a predecessor completion status is 100% then the status of this raw should change".
-
Average of multiple rows
Hi - I am running into a problem with finding the average of multiple rows based on the two previous columns. I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would then populate the 2017 and 2018 columns by Month on the other sheet. Any ideas would be…