I have a formula field that calculates a value (results a number) based on a lookup field (e.g. a date).
When the lookup field is empty due to a missing input, formula field results with a NaN or ERROR.
In that case, I want to highlight RED color to that record so operators understand that they should fix the missing input.
Unfortunately, there isn't a way to enter a color condition statement such as "WHEN formula field IS ERROR, SET COLOR red".
Is there a solution for this? @dashler78
Try to add an IF statement to the Formula field. This formula checks whether Date is input.
IF({Date},"TRUE")To check how the Lookup value is a date, it can be checked with this formula.
IF(NOT(ISERROR(DATESTR({Date}))),"TRUE")Normally, you only need to determine how empty it is, but if the date is taken from a string, you may need to check both.
By adding the IF statement above, you can set the record color to red when the formula field is empty.
Understood. It's a decent workaround. Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.