Check the Flag Revision



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. :)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!