I'm hoping to take my "Campaign" column and change the name of the line item if the date is prior to 11/1/2017 for a specific campaign.
I tried IF (Contains[campaign],"One+" AND date < 11/1/2017) THEN "Evergreen" ELSE "" ENDIF
But it's saying the date function won't work with a less than symbol. Any tips? Thanks!
Solved! Go to Solution.
Dates should be in the ISO format of: YYYY-MM-DD. The date 11/1/2017 should appear as: "2017-11-01"
Your formula might appear as:
IF Contains([campaign], "One+" AND [Date] < "2017-11-01" THEN "Evergreen" ELSE "" ENDIF
Cheers,
Mark
Perfect, thank you!!