Forum Discussion

MikkiHendry's avatar
MikkiHendry
Qrew Member
3 years ago

Creating a formula checkbox field based on task completion

Does anyone know the formula to use if I want a formula checkbox to populate when I mark a certain task complete? Thanks! ------------------------------ Mikki Hendry ----------------------------...
Formulas and functions
Relationships
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
Do you want this checkbox on the Project Record  or the Task Record?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MikkiHendry's avatar
MikkiHendry
Qrew Member
3 years ago
I would like it on the Project record

------------------------------
Mikki Hendry
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    Ok, we finally got there :). It was not clear from your original question that you had a second table involved.

    no problem, just go to the Relationship between Projects and Tasks and make a Summary field on the relationship and choose the option 

    Whether there are any children related to that Parent

    then include a filter like

    where Task Name equals Budget Approved




    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MikkiHendry's avatar
      MikkiHendry
      Qrew Member
      3 years ago
      Thanks!  I'll try and figure out what that means. :)

      ------------------------------
      Mikki Hendry
      ------------------------------