I’m going to try and explain this the best I can, and have provided a screenshot to help make sense out of my need for help.
I’m probably in way over my head, as I am learning formulas but I’m hoping for some help.
Here is what I’d like to happen:
(No zapier please…still learning)
Automatically add a check mark in followup box (hidden on example) if the ‘Status Change Date’ is over 14 days
Remove the #ERROR from the formula for those without dates. in the ‘Re’vd’ field.
Any help is greatly appreciated.