Skip to main content
Question

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

  • October 10, 2019
  • 0 replies
  • 24 views

​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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 10, 2019
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
------------------------------