-
JOIN COLLECT IF Statement
Hello Team, I have the below formuale which works just fine. However, I need to add a condition to this wherein it only picks those 'Program Status' which are 'Active' How do I add the IF Statement to the current string. =JOIN(COLLECT({Program Name}, {Project Health}, [Red Status]1), ", ") Thanks.
-
Pie Chart is Grayed out in Dashboard
I have a dashboard that was working correctly with a pie chart widget. Now the pie chart is grayed out and is no longer an option. The data does have values greater than zero so I'm not sure what the issue is. Especially since it used to work just fine. This is the formula I am using in my summary sheet to get a count.…
-
Formula incorrectly stating two cells are not equal
I have two columns, one is an index collect formula and the other is a simple subtraction of two cells. I want to create a formula to display a message if the two cells are not equal. I created the following formula '=IF([UOB QA]1 <> UOB1, "Check UOB")' and as you can see below, the two columns are identical and it's still…
-
Enter number in cell based on which checkbox is checked
I'm new at this so patience is appreciated. I want to fill a cell with 2%, 4% or 6% based on one, two or three checkboxes. If checkbox Credit 1 Complete is checked, Credit Obtained = 2%; Credit 2 complete, Credit Obtained =4%; and Credit 3 complete checked, credit obtained =6%. Credit Obtained cannot be 6% without the…
-
Adding values together with different conditions.
Hi everyone, So what I am trying to do is compare job numbers from different days of the week, and if those numbers are the same then add the Per Diem values together. Here's the formula that I'm using so far. By the way the formula resides in Column Job 1. =IF(OR([Monday Job]@row = [Tuesday Job]@row, [Monday Job]@row =…
-
Can you use formulas in filters?
I am attempting to create a report that pulls from 11 sheets that are being manually updated weekly. I want the report to only show the most current week results from the 11 sheets. I am struggling to find a way for the report to always be pulling the most up to date information but I can only seem to enter a single value…
-
Graphing / Rounding / Millions
Can I recreate this GRAPH / Dashboard The numbers are defaulted to Millions; they are presented in our sheets as $5,100,000 and $3,180,000, respectively; however, for ease of visualization, we want to round them and graph them as shown. HELP!
-
issues with If and vlookup - adding up by 1 point -
I had a spreadsheet of results of 5, 4+, 4, 3+, 3, 2+, 2, 1+, 1, and 0, and each of those numbers has a point value in another spreadsheet. For some reason, it would count twice. If I look up 1, the one value will give me an extra point (I assume because of 1+). How do I ensure they don't do that? The following formula I…
-
Automated Drop down or Formula?
Hi all, I was wondering if there is a formula or drop down function that can auto populate words or drop downs? As seen in my conditional formatting for "Days Left Till Expiration it conveys whether if it is red, Yellow, Or Green based on the amount of days passed or upcoming till a Term end date. I'm wondering if I can…
-
How do I replicate data from one cell to another cell in SAME sheet
How do I duplicate/replicate cell data from column A, to another column in same sheet, Column B. I know how to link cells to another sheet but not in same sheet.