If a “x” value is present and the column header is today’s date how do we display true/false
I have a workbook that I am trying to update to display the status (red or green) in cell AB1 of the lab in a singular cell based on =Today(). The table is a calendar format but due to some other pivot tables and other data validation features they have some separating columns (an example workbook is attached). The basic function of this is to track the daily events in each category/swim lane. An x marks that that issue happened on that particular day. So I am trying to come up with a function that will search the table for the specific date and if there are any x’s in the column below to then have a true/false scenario. I was searching through V/XLookup, MATCH, and IF functions but they all don’t quite seem to fit.
Anyone have any advice?
Also to note, secondary issue is that I wasn’t able to have the dates as the specific column headers in the tables so I opted above but if there is a solution to that as well, I’d be very grateful. Any formula I try doesn’t stick as it needs to be referenced to the year input as this is a rolling template from year to year.
Thank you so much,
Nyssa
I have a workbook that I am trying to update to display the status (red or green) in cell AB1 of the lab in a singular cell based on =Today(). The table is a calendar format but due to some other pivot tables and other data validation features they have some separating columns (an example workbook is attached). The basic function of this is to track the daily events in each category/swim lane. An x marks that that issue happened on that particular day. So I am trying to come up with a function that will search the table for the specific date and if there are any x’s in the column below to then have a true/false scenario. I was searching through V/XLookup, MATCH, and IF functions but they all don’t quite seem to fit. Anyone have any advice? Also to note, secondary issue is that I wasn’t able to have the dates as the specific column headers in the tables so I opted above but if there is a solution to that as well, I’d be very grateful. Any formula I try doesn’t stick as it needs to be referenced to the year input as this is a rolling template from year to year. Thank you so much, Nyssa Read More
