Forum Discussion

KatrinaE's avatar
KatrinaE
Qrew Cadet
6 years ago

I need a text field that will yield different values depending on different conditions.

I have posted about this a few weeks ago but I still need the right formula to it.  I need a text field that will yield different values depending on different conditions.  I need a field that will prompt "NA" if a project has been started on time, and them it will prompt L1 if the project is less than one day before the assigned start date and L7 if it's 7 days before the due date.  This is what I have currently