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
------------------------------