Calculate if 15 days or greater from a column date, then return "X", otherwise return "Y"

[HaloKay]

Hello,

I have a column called "Action Needed" that has alot of If conditions such as if:

[1st letter request date] = blank( ) && [Records received] = Blank ( ), "Request letters"

I am wanting to return a result of "Send 2nd request for letters" if today's date is 15 days or greater from [1st letter request date] otherwise it will be "Waiting on letters" which means it's less than 15 days from today.

I came up with but not sure: [1st letter request date] >= today () - 15 &&, "Send 2nd request for letters", "Waiting on letters"

Thank you in advance!

[Jihwan_Kim · Accepted solution]

Hi,

If you aim to create a new column, please try something like below whether it suits your requirement.

new column CC =
IF (
    [1st letter request date]
        >= TODAY () - 15
        && NOT ISBLANK ( [1st letter request date] ),
    "Send 2nd request for letters",
    "Waiting on letters"
)

[HaloKay]

Thank you! I needed that NOT ISBLANK. This will help with the other actions I need to calculate.