Need to ID rows in list that need to be recontacted after certain
I have a contact list that is getting longer by the day and I'm falling
behind on follow up.
Every time I contact someone on the list, I update the date & time in a
specific column (let's say A). What I need is a formula that changes a
variable in a new column when I have not updated information in column A in a
long time (ie. 30 days). That way I can easily organize and prioritize my list
I have tried playing around with the IF function but can't seem to get the
date/time component to work for me. Any help would be GREATLY appreciated!!
|