Hello! We have a nomination form with several text/number columns where people can add the name of the person or people they want to nominate. Most columns have 1 nominee for each row, but some have m…
I am trying to create a helper column on my sheet that checks a box if the child rows have a due date within the quarter. Our quarters are based on the fiscal year July 1 to June 30. So far I have the…
I have a sheet and want to create a formula that looks at the info in a column named "Bill Status" and column named "Our Stance". Based on the combinations of the responses in these columns I want and…
Hello All, I am hoping this community can help me figure a particular scenario out: I have 2 Sheets: Sheet A, Sheet B I want to look at Sheet B: Find a unique identifier in Column A (this is also the …
I have a working formula that I'd like to add a condition to, if possible. Here is the working formula: =IF(ISERROR(MEDIAN(COLLECT({Resi - Pricing & Tools Duration}, {Resi - Enter Stage 7 Date}, AND(@…
Hello all, I have a working formula but I want to not JOIN COLLECT the value on the current row (@cell) e.g. in the clashes column, row 3 would just return 'Sub Task 1' and row 4 and 5 would be blank …
Hi, I am trying to extract the first and last name from an email address with the names in proper form (first letter capitalized). Is there a formula to do that? Here is an example of what I'm trying …
I am looking for a formula to remove any line of data that has a value of zero in the Report, from the Dashboard. So, when the line of data is zero in the Report, it should eliminate that row from the…
=IF([% Complete]@row < 0.1, "Not Started", IF([% Complete]@row > 0.1, AND ([% Complete]@row < 0.99, "In Progress", IF([% Complete]@row = 1, "Complete")))) I need help with this formula. I need the row…
I'm trying to pull publishing locations from a column in a sheet using Project ID. The first part of the formula and last part of the formula seem to be okay, I get the "Edit" option if I click on the…