Discussions

Expand all | Collapse all

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

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

    Posted 05-16-2018 20:26
    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


  • 2.  RE: Formula checks if value in field is Approved for all like items, then return ""All Approved

    Posted 05-16-2018 20:49
    Do you gave any relationships?  Does 1 Road have many Permits?


  • 3.  RE: Formula checks if value in field is Approved for all like items, then return ""All Approved

    Posted 05-17-2018 01:17
    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.


  • 4.  RE: Formula checks if value in field is Approved for all like items, then return ""All Approved

    Posted 05-17-2018 01:22
    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"))


  • 5.  RE: Formula checks if value in field is Approved for all like items, then return ""All Approved

    Posted 05-17-2018 02:00
    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.