Forum Discussion
Solved
Setting up alert on a different page
Hello. Is there a way to select a whole row of dates, all will be different, and set an alert to go off in a different location ie - sheet 2 or Word? Thanks in advance.
Suppose the column A is the list of dates with A1 as the header.
Then, in column B, I would try the following formula (in cell B2):
=IF(and(A2-today()<7, A2-today()>0), "ALERT", "")
Hope that this can help you.
Sorry i meant to say set the alert to come up within a week of the due date
Suppose the column A is the list of dates with A1 as the header.
Then, in column B, I would try the following formula (in cell B2):
=IF(and(A2-today()<7, A2-today()>0), "ALERT", "")
Hope that this can help you.
- Once again thamk you for your help.
- Sorry one more question, is there a way to set the alert up for dates that are after todays date?
The function today() will return the value of today, so the following formula will help
IF(A2 > TODAY(),"ALERT","")
- Thank you, with a few small tweaks i figured out what i needed. Your help is appreciated.