Forum Discussion

RachelMiller's avatar
RachelMiller
Qrew Cadet
6 years ago

How do I add an If statement to a List formula?

​I have a formula text field called Calendar Label that currently has a formula of: List("",[Application/Tool],"~",[Task]) I want to add a statement that says: If [Complete]=true change the ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Try this as a formula Rich Text field type.

IF([Complete], "<b>")

&

List("",[Application/Tool],"~",[Task])

I want to add a statement that says:

If [Complete]=true change the font to bold

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • RachelMiller's avatar
    RachelMiller
    Qrew Cadet
    6 years ago

    Thanks Mark.  That worked perfectly!

     

     

    Rachel

     

     

     



    ------Original Message------

    Try this as a formula Rich Text field type.

    IF([Complete], "<b>")

    &

    List("",[Application/Tool],"~",[Task])

    I want to add a statement that says:

    If [Complete]=true change the font to bold

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------