Hi,
I have a pivot table with data columns and I need to apply conditional formatting on 3 columns based on the following criteria.
1. Action Status column as "Completed" should be highlighted as green.
2. Action Deadline Date column should be red if the action status is not completed and the...
Attached are the 2 files for your review. In the SAM Monthly Report Test file. I am trying to achieve the following.
I want pervious monthly records for employee only where the "Injury Type" is not "First Aid" or "Reported Only".
This is what I have written with the Error function, but its not giving me the right data.
=IF(ISERROR(INDEX('[Safety Stats.xlsx]Occupational Injuries'!$J$5:$J$128,SMALL(IF('[Safety Stats.xlsx]Occupational Injuries'!$A$5:$A$128=TEXT(EOMONTH(TODAY(),-1),"MMMM"),IF('[Safety Stats.xlsx]Occupational...
Below is my formula which is giving me a #NUM!. How can I fix it. I have to spreadsheet. One with the data called "Safety Stats" and the other one is actual report where I am using this formula to pull the record from the data file i.e "Safety Stats"
=IF(INDEX('[Safety Stats.xlsx]Occupational...