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

  • 0
  • 1
  • Question
  • Updated 2 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 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
I think your post was incomplete here. What was wrong wi5 this Solution here.
https://community.quickbase.com/quick...