Check the Flag Revision

CherylAK

Hello,

I recently posted on how to get the flag to go red under certain conditions. I can't remember who answered my question, but he was very helpful. I now have another issue and I'm hoping there is a revision to my formula.

My formula is =IF(InitiationDate@row < TODAY(-30), true, false)

My problem is if there is no date in the InitiationDate Column, then the flag automatically turns RED. I would like it to be BLANK like the dates that are newer than 30 days.

Is there something I can add to my formula so that if the InitiationDate field is blank, then the flag will not be red??

Thank you VERY much for any hlep. :)

Paul Newcome

If you right click on any cell containing the formula, you can select the option (near the bottom) to convert to a column formula.

CherylAK

OMG...you are a genius!! I never even saw that down there at the bottom!!! It works like a champ!

I really, really appreciate your help..and so fast too.

Myself and a co-worker will be attending the Engage Conference in September. If you are going, we should try to meet up for lunch!

Thanks again,

Cheryl

Paul Newcome

Try this:

=IF(InitiationDate@row <> "", IF(InitiationDate@row < TODAY(-30), 1))

CherylAK

Thank you so much. I will give it a try!!

CherylAK

Ok I gave it a try, and it does work. But after the first row it does NOT work. I see that the formula does not drop down to the next line. I dragged the formula down the column and then it worked.

Will I have to do this? Or is there something in the formula where it automatically will work for each line?

My initial formula automatically dropped when a new line was entered.

Let me know. Thank you so much for your help. I am getting closer to solving this because of you!

Paul Newcome

If you right click on any cell containing the formula, you can select the option (near the bottom) to convert to a column formula.

CherylAK

OMG...you are a genius!! I never even saw that down there at the bottom!!! It works like a champ!

I really, really appreciate your help..and so fast too.

Myself and a co-worker will be attending the Engage Conference in September. If you are going, we should try to meet up for lunch!

Thanks again,

Cheryl

Paul Newcome

Happy to help. 👍️

I will actually be at ENGAGE this year. Definitely feel free to track me down!