Formula checks if value in field is Approved for all like items, then return "All Approved"

  • 1
  • 1
  • Question
  • Updated 7 months ago
  • Answered
Need a field where for each Permit, check if status=Approved for permits with SAME Roadname, and if all = Approved, then return "All  Approved" for that Roadname
Photo of Ruby Kapil

Ruby Kapil

  • 880 Points 500 badge 2x thumb

Posted 7 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Do you gave any relationships?  Does 1 Road have many Permits?
Photo of Ruby Kapil

Ruby Kapil

  • 880 Points 500 badge 2x thumb
Yes 1 Road can have many permits.
If all Permits for that Road have status of Approved then that Road status is Approved. If any Permits for that Road show anything other than Approved, then that Road status is Not Ready.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
No problem.

Make a summary count field of the # of Permits.
Make a summary count field of the # of Approved Permits.

Then make a formula text field

IF(
[# of Permits]=0, "No Permits",
[# of Permits] = [# Approved Permits], "All Approved",
totext([# Approved Permits]) & " of " totext([# of Permits]) & " Approved"))
Photo of Ruby Kapil

Ruby Kapil

  • 880 Points 500 badge 2x thumb
Dear Champion, you are AMAZING!
Provided just what I needed, logic worked!
Thank you, my friend. You have given me the trick I needed to make many of my reports come to life.