Hi, I am not sure if this is possible, but I have data, where a status column is in column G.
I use a Vlookup to return a comment from a tab called "Status codes" This formula is put into column T =VLOOKUP(G2,'Status Codes'!A:B,2,FALSE
The problem I have is that I also have to insert a comment where the dates in column M is more than 3 days older than todays date. I have this formula working in another column W
, =IF((NOW()-M4)>3, "No CLM Update in 3+ days", "") but I need it to also be put into column T but only if the row in blank for column T.Is this even possible?
SO basically only do the Date calculation part, if the "comment" column is blank for that row?
I use a Vlookup to return a comment from a tab called "Status codes" This formula is put into column T =VLOOKUP(G2,'Status Codes'!A:B,2,FALSE
The problem I have is that I also have to insert a comment where the dates in column M is more than 3 days older than todays date. I have this formula working in another column W
, =IF((NOW()-M4)>3, "No CLM Update in 3+ days", "") but I need it to also be put into column T but only if the row in blank for column T.Is this even possible?
SO basically only do the Date calculation part, if the "comment" column is blank for that row?