Hi Community
How can I change the color of data table rows depending on the "Abgabetermin"? The goal is that 7 days before the deadline day the corresponding row turns red.
It is unclear to me how to set up the formula if I do not have a TemplateFill control in my data table...
Basically I use one of these modern ready-made canvas templates.
If(
DateDiff(Today(), ThisItem.Abgabetermin) <= 7 && DateDiff(Today(), ThisItem.Deadline) >= 0,
RGBA(255, 0, 0, 0.2),
RGBA(255, 255, 255, 0) // Default color
)
I am grateful for any help or tips
Greetings