Forum Discussion

Qrew Trainee

4 years ago

Formula Error Message

I *think* I have a formula written for my needs (I am very new to this), however when I try to insert it I receive a error message. Screenshoots attached as well. Formula: If(IsNull([Appointme...

Formulas and functions

MarkShnier__You

Qrew Legend

This should be a field on the table as a Rich text fomrula field and not a Custom data rule.

Try this to fix the formula.

If(
IsNull([Appointment Scheduled]) and ToDays(Today() - [Appointment Needed By]) >=1 , "<span style=\"color:#ff0707; font-weight:bold\">"&"OverDue"&"</span>" ,

IsNull([Appointment Scheduled]) and ToDays(Today() - [Appointment Needed By]) >=-7 , "<span style=\"color:# FFDD33; font-weight:bold\">"&"Upcoming"&"</span>"
)

// I left out the last part of the formula as it was incomplete.

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

MeaganMcOlin

Qrew Trainee

4 years ago

Mark,

Now I'm going to ask what is probably a ovbious question, but where do I find the Rich text fomrula field?

------------------------------
Meagan McOlin
------------------------------

MichaelTamoush
Qrew Captain
4 years ago
When you create a field (just like when you created [Appointment Scheduled], if you keep scrolling down the list of options, you will see a big selection of formula fields available. Formula Rich Text is one of the options!

------------------------------
Mike Tamoush
------------------------------