-
How to checkbox when first and second criteria match in a dropdown list
Hi fellow team members, I can't figure how to check a box when first and second criteria match in a dropdown multi select list. Please reference below. Here's an example of what I am trying to accomplish. I want the column with the checkbox to 'Check' when the all the values in the 'List of Tests' column has been assigned…
-
How do I +20
I have a column labeled - "year updated" In the first cell under it I put 2020 from a drop down menu In the next column over and in the cell next to it I want to apply (year updated column cell 1) the (2020) cell and add 20 to that 2020. I have the other column I am trying to populate set up as text/number. So when I…
-
At Risk Flag Count
I have a formula set up to capture when a flag is activated, i.e. when the Status is in the past, the flag is activated (unless the Status is On Hold, Cancelled or Complete). I also want the flag to be activated when the Status is changed to Unresourced, but can't quite work out that piece of the formula. Please can…
-
Why does =TODAY() - Created@row give inconsistent results?
I have an auto number column [Created] that captures the time a row is created. In another column [AGE], I am trying to calculate the age by using the formula =TODAY() - Created@row. For some of the rows created today, this formula gives an AGE of 0 days, but for others it results in -1. What am i doing wrong?
-
IF/AND
Hello, There may be a more efficient way to solve this so please feel free to suggest an alternate way. I have a column in my sheet that collects the time/date a form is submitted using the "Created - Date" field option . I need to set up an automation that would be triggered by the time the form was received AND the day…
-
Flag is true when status is not complete and date modified is 5 days old
Hello, in an effort to automate update request emails for items that have been stuck at a specific status for a period time, I am trying mark a flag as true when the row status is not complete, and the date modified is more than 5 days old. I think I need an IF And formula and having difficulty incorporating the and…
-
Can I create new column restricting values of a "Dropdown (Multi Select)" column to a subset?
I have a sheet with 4 columns: Column2 is a "Dropdown (Multi Select)" restricted to 4 values. I created Column3 by hand, restricting the values from Column2 to the subset {Person 1, Person 3}. Is there a formula I can put in Column4 that will make it reproduce Column 3?
-
Find the Percentage of the Total
Hi! I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I…
-
Nested IF/AND Formula
I'm receiving an #UNPARSABLE error for the following formula: =IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1", IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2", IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))…
-
Health Status Formula dependent on due date
I am experiencing trouble trying to write a formula for the below situation. See above screenshot as reference. Can someone please advise on how to write this formula correctly? This is the current formula I'm using, but I know it's not correct: =IF[On Hold] = 1, "Gray", IF([Due Date]@row >= TODAY(15), "Green", IF(AND([Due…
