Skip to main content
Question

Formula help

  • Dec 22, 2022 6:14 PM UTC
  • 0 replies
  • 35 views

Help lol!!! Im new to formulas and im trying to get my report to only show projects with certian task open but only if other task are closed.

EXP:

Show all projects that have install task open but only if the permit task is closed

------------------------------
Stephanie Delahunty
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • Qrew Colonel
  • Dec 22, 2022 9:13 PM UTC
So you can set this using the 'filter' section of the report builder.   If you show us what you have so far we can probably help better.

------------------------------
Jeff Peterson
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
OK, you have a relationship where one project has many tasks. Go to that relationship and create a summary checkbox field for ANY task where the type is Permit and the Status is closed.  Call this [Any Permits closed?].
Then create a new summary checkbox field for Any Tasks of type Install where the status is Open.  Call this [Any Open Install Tasks?]

Then simply filter the project reports where those two fields are checked.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------