-
Formula for percent match to a multi select column
Hi, I'm working matching mentors and mentees. We would like to match them based on attributes they both selected in a multi select column. As in, choose your top three competencies. Now I would like to make a formula to determine the percent match of a mentee to a mentor's selection. That is Mentee 1 selected A, B, and C.…
-
Formula Question for Percentages into Risk Status
Hello, I am trying to have the formula below also reflect that if the percentage is 0% it automatically has the risk status show as blue. Could someone please assist with this? =IF([% Complete]@row = 1, "Green", IF(AND(Finish@row <= TODAY(1), [% Complete]@row < 0.51), "Red", "Yellow")) Thank you!
-
SUM IF formula upon specific criteria
Hello, I was looking for right formula to SUM IF upon specific criteria (KMF662), and how many fuel has been used over they May (sum only May). I want to apply this formula to each month separately, according to a separate car. Thank you for your answers in advance.
-
Summary reporting with conditional formatting
Hello! I'm trying to build out a way to dynamically report on 58 state/territory sheets. Ideally, this report would have the total number of rows in the state sheet, plus the number of rows that meet two separate sets of conditions, with conditional formatting applied. I've tried doing this two ways: By using a sheet with…
-
Exclude and If statement then "" and based on date then "Return Value"
=IF([Tier Status]@row <> "Group D", IF([Escalation Required]@row, <>"", (IF([WM Next Meeting Date]@row = "", "No Meeting Scheduled", IF([WM Next Meeting Date]@row = TODAY(-14), "Pending", IF([WM Next Meeting Date]@row > TODAY(-1), "Scheduled", IF([WM Next Meeting Date]@row < TODAY(-14), "Overdue"))))),"Escalated")) What…
-
I want my Status column to give me a red circle when it detects a flag in my Critical column.
=IF([% Complete]@row = 1, "Blue", IF([% Complete]@row > 0, "Green", "Yellow")) I want to add there to turn red when it detects a flag in my Critical column. Please, help
-
Need to return a value with INDEX(COLLECT) but not if cell is BLANK
Hello, I am unsure if what I am doing is possible or not but I need to return a value with specific criteria. I need the latest "Revised Date" from the most recent amended version (Occurrence). However, it is possible the latest amended has no updated "Revised Date" field so it should keep the previous revised date.. In my…
-
Formulas to calculate the number of weekdays, Saturdays, and Sundays between two dates
I have three columns: Weekdays, Saturdays, and Sundays. I need to calculate the quantity of each of these three types of days based on start and end dates. The NETWEEKDAY and NETWEEKDAYS functions do not work in this case because the start and end dates should be included in the count. Example: Start date of 8/22/2021 and…
-
Forms - can you make formulas on dates?
can the sheet have a formula when the form selecting a date - gives a response? =IFS([@Response]="", " ", OR(WEEKDAY([@Response])={1,7}), "That is a weekend date. Please select a different date.", OR(WEEKDAY([@Response])={2,3,4,5,6}), TEXT([@Response], "dddd")) where the form entry will prompt a new suggestion?
-
Link to another sheet and conditionally output
Hello, I have one sheet that I am trying to link to and output data conditionally. There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with the LineItem record if the Department is "CF". Is there a function I can use to bring in this data? See…