O.K.,
I have a detailed question so please bear with me:
I currently have the following formula that works at the moment:
=IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = "Closed"), "", IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = "Open"), "Open Issue", IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = "Pending"), "Open Issue", "")))
I now have to somehow change the status from "3" to "1-5". Also, the total number will change from sheet to sheet (i.e. 1-2, 1-3, 1-4, 1-7, etc.). I'm trying to determine if I should insert an additional column that would total the number of columns and then feed the above formula or have a different approach all together. I attempted to attach the actual spreadsheet and provide a more in-depth description of what I was trying to do.
Any insight is greatly appreciated.
Thank you,