-
Difficulties Nesting formula
Hello all, I think I am close to the answer here but struggling to figure out what I need to add to the formula to. Looking for the formula guru's here. Here's what I need this formula to do. I think I am on the right path, hopefully. If "Lab Date Received" row is empty, return "Awaiting FER in Lab" If "Lab Start Date" is…
-
COUNTIF multiple Criterias
Hello there, i am trying to count the number of time certain names have been selected in a multi drop down list, in a specific range of time, while referencing another sheet. I've tried the formula below and getting an error =COUNTIFS({Phase}, CONTAINS("Complete", @cell), {Go live date}, >=[Column10]@row, {Go live date},…
-
RYG "Yellow" Error for Health Metrics in Summary Row
Hi Community, I am trying to create an overall health metric for a project based on the information in the summary row of the schedule. The criteria is a mix of fields: If the Status is on Hold = Blue If the Status is Complete = Blank If the Finish date has passed = Red If Today is within 7 days of the Finish Date and %…
-
Count a number between two dates
Hi, Do you know if there is a formula that will count how many rapports were produced between given dates (20-01-01) and (20-12-31) in the Created (Date) column for the person xxx? Thanks,
-
VLOOKUP to return value
I am trying to return a value in a sheet using data from one other sheet. Look up whether there is anything entered in the 3rd column OEM License Agreement. If true then return the Company Name, column 1. This is what I wrote: =VLOOKUP({00 CF/CI OEM-Fab Agreements [MASTER] Range 4}3,{00 CF/CI OEM-Fab Agreements [MASTER]…
-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…
-
Using COUNTIF only if it qualifies...
I am trying to create a status report for items started. I think I have the formula for how many assigned, but now I need to identify of those assigned to 1 person, how many are started by that person. I tried =COUNTIF({Course Started}, {Team Movement Range 1"Donald Duck"}1). In the pic below Donald has 2 courses assigned…
-
Extract the 'hour' out of a date format
Hi there I'm trying to pull out the start time of the meeting and the end time of a meeting so I can have the duration of a meeting - i.e. 1 hour. The date format for a meeting is being pulled through like this: 2020-11-27T10:00:00Z The end time for this meeting is 2020-11-27T11:00:00Z I want to pull the duration of the…
-
Sheet summary sum function
The column I am attempting to sum is using a cross sheet reference to pull data in from another sheet. When I use a sum formula in the sheet summary field it is returning a no match. I'm assuming the sheet summary fields are limited to actual values but figured I would ask.
-
Using countifs with a criteria to count distinct values
Hello, I am trying to count the number distinct values with status colors that are red, yellow, or green. We have the same property IDs with multiple line items. Therefore, I am trying to count multiple property IDs as one distinct value if they have a status of red, yellow, or green. The logic would be count distinct…
