Forum Discussion

JemmaDicks's avatar
JemmaDicks
Qrew Trainee
3 years ago

Display field only if checkbox is not empty

This is very straightforward but I can't figure it out in my own because i'm a noob. 

I have a checkbox field called [Profit-share arrangement]
If this is selected, there is a follow up question called [Profit-share arrangement appropriate]

I need to know the syntax to include in the follow-up question's formula field to only display this if the checkbox is checked. 

e.g. =IF([Profit share arrangement]=TRUE.....?

------------------------------
Jemma Dicks
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    No problem

    IF([Profit share arrangement]=TRUE, "My words go here")

    unlike excel, you do not start formulas in Quickbase with a plus or an equal sign.




    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      3 years ago
      Also, if you're lazy like me, you can save a couple keystrokes by omitting the "=TRUE".  

      IF([Profit share arrangement]=TRUE, "My words go here") and IF([Profit share arrangement], "My words go here") will both produce the same result.

      ------------------------------
      Paul Peterson
      ------------------------------