Forum Discussion
Return text based on text and date
I'm trying to create a column which looks if text in Column A = "" (Which means it is unassigned), and if the deadline date is within 7 days of todays date. I've tried lots of different things bu...
You need a comparator in your Date.AddDays function. At the moment, you are saying "if assigned to is blank, or (deadline date minus 7) then high, otherwise low". You need to say "if assigned to is blank, or (deadline date minus 7) IS LESS THAN TODAY then high, otherwise low".
Try:
if [Assigned to] = "" or Date.AddDays([Deadline Date], -7) < DateTime.LocalNow() then "High" else "Low"
or:
if [Assigned to] = "" or Duration.Days(DateTime.LocalNow() - [Deadline Date]) < 7 then "High" else "Low"
The syntax may not be exact but I hope you get the idea.