If Else Statement to Input in a Yes/No Field
Hello! I am currently working on a field that ask whether or not a project is +140 days over its due date. I have the field "Over +140?" as a Formula - Rich Text. There is another field I am basing...
Forum Discussion
If(
[Days Past Due]>=140,
"<div style='color:red'>Yes</div>","<div style='color:green'>No</div>"
)
the comma separating the two html elements is like "else".
If days past due is equal to or greater than 140, then, Yes in red, else, No in green.