Skip to main content
Question

Formula Error Message

  • June 23, 2021
  • 0 replies
  • 41 views
MeaganMcOlin
Forum|alt.badge.img+7

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([Appointment Scheduled]) and ToDays(Today() - [Appointment Needed By]) >=1 , "<span style=\"color:#ff0707; font-weight:bold\">"&"OverDue"&"</span>" )
If(IsNull([Appointment Scheduled]) and ToDays(Today() - [Appointment Needed By]) >=-7 , "<span style=\"color:# FFDD33; font-weight:bold\">"&"Upcoming"&"</span>" )
If(not(IsNull([Appointment Needed By])),$green,

Error Message: 

There are extra characters beyond the end of the formula



------------------------------
Meagan McOlin
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement