-
Contact name appearance is different across sheets
Hi, Please can you tell me how I can fix the way my contacts are appearing across 2 sheets. In one sheet I get 'Name Surname', in another sheet for the same person I'm getting 'name.surname@codomain.com'. This is happening for 3 out of the 10 people in that sheet so not consistent within the sheet. How can I standardiseβ¦
-
How do I set several cell values to a specific value in a different column
Hi, I am running into issue and I cannot think about a way to solve it. I have a column (Drop-down list) containing specific statuses (Status Column) which I need to match to 5 different report statuses (Not Started, In Flight, On Hold, Cancelled, Completed). The match is as follow: I can match the "Not Started" and "Inβ¦
-
Join/Collect Function if status of row within hierarchy is "Next Up"
Using the [Next Up] Column in row1 (the parent row) I'm trying to join the [Onboarding Effort Name] and [Due Date] text of whatever row has the "Next Up" status. The task labeled as "Next Up" will continue to change, the hope being that the "Next Up" row will auto update with the task name and due date of whichever row isβ¦
-
Formula that counts based on two variables by month and year
Hi Community, I was able to find a formula here for counting how many times an employee was assigned to a task by month and date. =COUNTIFS({Administration and Support Task List Range 3}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021), {Administration and Support Task List Range 2}, "Employee") I'd likeβ¦
-
Counting Multi Select Drop Down Data in grid
I have a ticketing system for guest responses in a satisfaction system. While I read the comments, I'm manually assigning over arching buckets based on that comment - e.g. Cleanliness, Maintenance, Service, Condition, billing, facilities, etc. I probably have 40 + buckets based on comments. I'm looking for a way to createβ¦
-
Contact List Formula
Hello, I'm not sure if my approach is correct but I'm trying to use an IF statement in a contact column to have a specific contact listed based on the value in another column. The formula is fairly straightforward, but the problem I'm having is the IF statement displays the result as text. I did some digging and thereβ¦
-
Need Formula for Top 3 (or maybe 5) of a ranked array
Is it possible to return the value in the "Rows" column below for the top 3 numbers in the array? So I would want to return "Data Quality, Governance & Reporting", "Talent, Skills Availability" and "Configurability vs Programming" from the array below. In a sheet I have 6 people ranking the items in the Rows column 1-10. Iβ¦
-
Countif formula that counts that row if the date on one column matches the date on the other column?
-
Due in the next 7 days - Parent/children formula
Hi all, I'm looking to create a formula that looks through the children of a parent and assesses whether it is due in the next seven days and then as a separate formula assesses which are overdue too. Currently I have: =COUNTIFS(CHILDREN([End Date]101), CHILDREN([% Complete]101) <> 1, AND(@cell >= TODAY(), @cell <=β¦
-
VLOOKUP -to auto-populate columns
Hi I would like to auto populate the status of the contracts from one sheet to another. How could this be done? The sheet below contains the status of the contracts . There is another sheet I want this to be referenced when they enter the contract number: Could you pls help me with the formula to do this? Thanks Ranjiniβ¦