Formulas
Discussion List
- 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…
- 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 (Vary…
- 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 bein…
- I have a set of data where I am trying to do 2 things: Find the top 5 highest values in a row. I used a LARGE formula to find the values in the 1st-5th highest spots (seen in rows 9-11). Find the name…
- I am trying to label the overall health of my projects If all symbols on my range are green, I want the overall cell to have a green symbol. If one or more symbols on my range are yellow, I want the o…
