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

Question

​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 font to bold
The Complete field is a checkbox and I'm not sure how to add it into my existing formula without getting an error.------------------------------Rachel Miller------------------------------

rachelmiller · Answer

Thanks Mark.&nbsp; That worked perfectly! &nbsp; &nbsp; Rachel &nbsp; &nbsp; &nbsp;------Original Message------Try this as a formula Rich Text field type.IF([Complete], "&lt;b&gt;")&amp;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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

markshnier__you · Answer

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

Forum Discussion

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

2 Replies

Related Content

formula help "if statement"

Combining Multiple Text Lists into One Text list Field

Dynamic Rule - Or statement?

Jinja If statement equals field value

Total Formula with 2 IF statements