Hi Guys, I have the below formula in the text property of the label within a Gallery which Items are going from a collection called colERAll and it returns the correct count, however, I thought that if I use the same for the colour property using If(), like so;
Text: CountIf(colERActionsAll, Value(EducationReviewID) = ThisItem.ID && OpenAction = "1")
Color: If(colERActionsAll, Value(EducationReviewID) = ThisItem.ID && OpenAction = "1" && DueDate = < Today(), Red, Black)
This would work, but I get errors, even just trying this in the color property: If(colERActionsAll, Value(EducationReviewID) = ThisItem.ID && OpenAction = "1", Red, Black), it says expecting boolean value. I also cannot seem to get the correct field, like DueDate to function within the color formula.
I guess I need a revised If statement, as I would need to also to get the data from colERActionsAll, using the EducationReviewID as the reference.
Text: CountIf(colERActionsAll, Value(EducationReviewID) = ThisItem.ID && OpenAction = "1")