Formula for today's date minus 3 days

Mary Anne Dunn

I used the formula creator to drop a true or false in a column so I can use it for conditional formatting the row. This is what the system helped me create, however, when I changed and saved Assignment Date the field still shows False. I expected it to change to True.

Thank you!

Mary Anne

kowal

Hi Mary Anne,

I assume the Assignment Date is the 1st of September 2024 - so it's much more than 3 days ago that's probably why it still shows false. Today is 2nd of October so for this formula to show True the date would be like 30th of September.

Let me know if I understood your problem correctly.