# Testing various Field successively

• 0
• Question
• Updated 3 years ago

I have six date fields which signify a successive progress on a project.  I am trying to categorise the progress textually by by selecting first date, then first and second date, then first, second and third date etc. Is there a better option to achieve this where I check the fields filled in?    As an example I am using following formula which likely to increase in length once I add more.

If(

[Store Walk Not Required]<> true and IsNull([Store Walk Date]), "Store Walk Stage",

[Obj Validation Not Required]<> true and IsNull([Obj Validation Date]) and not IsNull([Store Walk Date]), "Validation Stage",

not IsNull([Store Walk Date]) and not IsNull([Obj Validation Date]), "Sign Off Stage",

[Pre FGCC Not Required]<> true and IsNull([Pre FGCC Sign Off Date]) and not IsNull([Store Walk Date]) and not IsNull([Obj Validation Date]) and [Latest Design Stage] = "GM Sign Off Plan", "Pre FGCC Stage")

• 3,152 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 67,780 Points
re: "categorise the progress textually". Can you give an example of the result you are looking for when various of these dates are filled in?
• 3,152 Points
Thanks.  I just edited my question with an example of formula I am trying to simplify. .

QuickBaseCoach App Dev./Training, Champion

• 67,780 Points
There is not a more elegant way.

The only problem with a long formula is your ability to read it and keep it tidy and in the proper sequence as QuickBase walks down each test looking for the first one that is true.

While there is a limit to how long a formula can be it is an insanely large limit,  which believe me, you will never hit.
• 3,152 Points