Hello there,
I have a cell that marks an action item as priority 1, 2, or 3 depending in criticality of the item. I'd like to change this from a manual entry and have it look at Column J (which is the due date column) and change the priroity of the number depending on the due date. If it's 0-7 days from due date I want it to be "1", if it's 8-14 days from due date I want it to be "2", and if it's 15+ days I want it to be priority "3". I'd also like the priority to change to "PAST DUE" if the due date has passed.
How might I go about doing this? I started with a simple formula (not trying to tackle the entire formula quite yet) with the formula below. But unfortunately I keep getting an error message:
Thoughts?
Thanks,
Lorne
I have a cell that marks an action item as priority 1, 2, or 3 depending in criticality of the item. I'd like to change this from a manual entry and have it look at Column J (which is the due date column) and change the priroity of the number depending on the due date. If it's 0-7 days from due date I want it to be "1", if it's 8-14 days from due date I want it to be "2", and if it's 15+ days I want it to be priority "3". I'd also like the priority to change to "PAST DUE" if the due date has passed.
How might I go about doing this? I started with a simple formula (not trying to tackle the entire formula quite yet) with the formula below. But unfortunately I keep getting an error message:
Code:
=IF((J7-TODAY()>=0,J7-TODAY()<=7),"1","2")Thoughts?
Thanks,
Lorne
Last edited:
