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

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
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 


Photo of Katrina E

Katrina E

  • 310 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
I think your post was incomplete here. What was wrong wi5 this Solution here.
https://community.quickbase.com/quick...