Check date and flag On
I want to check by dates if you need to call the customer by activating the red flag, this red flag will serve as a pending call to a customer CRM spreadsheet.
It is working correctly, it happens that when the date cell is empty the flag is turned on, can you ignore when there is no date to compare?
=IF([Call in date]3 < (TODAY() - 30); 1; 0)
Help Article Resources
Check out the Formula Handbook template!