-
Financial Year
Hi, our financial year (FY) runs from July to June. I want to be able to determine from a row date, the relevant FY. Dates are in format dd/mm/yyyy For example: any date between 1/7/2019 to 30/6/2020 will be FY19. Any date between 1/7/2021 to 30/6/2022 will be FY21. etc. I would prefer not to "hard code" any dates in the…
-
COUNTIF formula with CONTAINS not working
I am having an issue when adding a "contains" function to my "countif" function. I am hoping someone can assist. The current formula that I am using works perfectly for COUNTIF =COUNTIF({Import RFI's Range 1}, "ADCVD") When I convert the formula to include CONTAINS I get an INVALID ARGUMENT message.…
-
Index/Match Question, Display Time of meeting based upon the date
Here is my problem: I have 2 standing meeting slots, one on the morning and one in the afternoon. A meeting can be scheduled during the morning, during the afternoon, both, or none. Here is my need: I wanted to show if there is a meeting in either slot on a given day. Right now I can show if one meeting slot is filled but…
-
Formula to bring a list of the children rows into parent row
I need to be able to bring a list of the numbers listed in the Parcel ID column from the children rows into the parent row. Thanks, Tina
-
How to calcualate time difference
Hi Team, How to calculate time difference 10:00:30 AM Start Time - 11:12:00 AM Regards,
-
COUNTIF that will only count child rows when present
This is another slight spin off of another question I had asked. How would I structure the COUNTIFS formula to ignore the parent row if child rows are present? The main formula I am using is: =COUNTIFS({FOLLOW UP Range 2}, AND(@cell > DATE(2021, 1, 1), @cell < DATE(2021, 1, 31)), {Follow Up Contractors}, FIND("ACCURATE",…
-
How to get a date from another sheet
Hi, I am trying to get a date from another sheet showing the request date in my principale summary sheet, with formula index, match i am not able to get the date (20121-10-09) from the second sheet is showing an error, please help on this. Best regards
-
Activating a Dropdown Choice Via Checkbox?
Hello, I have a scenario where I have a column of checkboxes for users to check if approved engineering change order documentation has been sent to a supplier. I have another column with dropdown lists to select the status of the engineering change order. I would like the dropdown choice "Engineering Change completed" to…
-
VLOOKUP two or more search values
Hey Community! Can vlookup have more than one search value when referencing another sheet? Here's an example but returns error. =VLOOKUP(Participant@row, Milestones@row), ({Milestone Submitted},23,false)
-
Counting a Unique Name in a contact list that has more then one name in it
I have a contact column called "Team". A task will have multiple unique names in the "Team" cell that is working that task. I want to count how many task people are working on at the parent level for the task. I have a helper filed that list the level for a task called "Level" I found this formula on another post but I am…