-
Help on formula - Looking at two columns and depending on the responses in both
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 output of Win, Loss, Null. Column named Bill Status, possible options are: Active Dead Enacted Column named Our Stance,…
-
INDEX/COLLECT Formula Help
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 same unique identifier in Sheet A, Column A), then look at column C to see if it's blank. If it's not blank, I want a…
-
Adding Checkbox Not Checked to Working Formula
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(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023, 7, 31))))), "", MEDIAN(COLLECT({Resi - Pricing & Tools Duration}, {Resi -…
-
JOIN COLLECT excluding value on current row.
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 My formula: =JOIN(COLLECT([Project Name]:[Project Name], [Person 1]:[Person 1], [Person 1]@row, Start:Start, Start@row >=…
-
How do I extract first and last name from an email address in proper form?
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 to do.
-
How can I automatically remove data with a value of zero from a Dashboard
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 Dashboard.
-
IF Formula Help
=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 to say Not Started if % Complete is 0%, Complete if 100%, and In Progress otherwise. Help Please!
-
How do I fix my IFERROR(INDEX) formula to pull data from a single sheet?
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 them, but the MATCH portion is giving me the "reference another sheet" message. Here is my formula: =IFERROR(INDEX{CE&T ARCHIVE…
-
Add Months to Date formula?
I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple. I'm trying to add a certain number (Varying) of months to a start date to produce an end date. I have a start date column (which is a date column), a column that…
-
Master Column to Reference Answer from Multiple Columns
I am trying to find an equation that will help me reference text found in multiple different columns to a master column. My "master column" is the column titled "SO Program". Based on the answers being submitted from my form, I would like the answers/text to to populate to the 'Master Column'. So if 'SO Malaysia' is…
