Formula to Trigger Checkbox if Date Meets Criteria
I have set up a formula column for a checkbox that I would like to use to compare against a date field and decide whether check box should be "checked" or left blank.
Essentially I'm going for: IF the Date on the row is greater than X amount of days old (for example lets say 90), then true (box is checked), and if it is not, then false (remain unchecked).
I'm currently trying to use an IF statement to compare against TODAYS DATE minus 90 days however I don't think this is giving the desired result.
Any suggestions would be most helpful,