So I found this helpful article https://support.airtable.com/hc/en-us/articles/221104988-Conditional-formulas-with-emoji
and used the
IF({Completed} = 1, “ :white_check_mark: Done:white_check_mark:”,IF(IS_BEFORE({Due date}, TODAY()), “ :alarm_clock:...
So.
It worked, awesome. BUT - I am wondering if I can keep a WIP or “in
process”, or even “blank” But when the task is within 3 days, go to Due
Soon.
BTW<
thanks so much
