DataCard Validation

[JR-BejeweledOne]

I am wanting to set a font color on a data card based on a validation formula and am getting an eval error.

This is a SharePoint form, and the column type in SharePoint is a number.

The error is "Incompatible type.  We can't evaluate your formula because the values being compared in the formula aren't the same type".  There aren't any property 'overloads' for DataCardValue2 other than visual properties and the text property which won't work because it needs to be a number, so I am not sure how to revise this.

[eka24 · Accepted solution]

Try:

If(IsBlank(DataCvarValue2) And Mod(Value(DataCvarValue2.Text),5)<>0,Green,RGBA(56, 96, 178, 1))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.