Highlight repeating group cell if contents created in last 300 seconds

I am wanting to highlight a row if the contents of that row were created within the last few minutes. Each of the rows is a feature suggestion, so basically I want to highlight any feature suggestion entered in last few minutes.

I’ve drawn a shape, put it in the background and figured I’d add a condition that said:

If current cells Feature Suggestion’s Creation Date > Current Date/Time: -300 Seconds

But there doesn’t seem to be a way to enter that.


I get as far as the screenshot above and then the options to add what I want to add don’t seem to be available.

What is my mistake?

Try Current date/time minus creation date <= 300s or if that isn’t allowed, something like if Current date/time minus 300s <= creation date. I’m not in front of a computer right now to try but something along these lines should work.

1 Like

Thanks for your input Louisa. It spurred me on to get it sorted :slight_smile:

I managed to do it with current date/time - 10000 seconds < Creation Date

(I"m paraphrasing there as that’s not the exact syntax but close enough).

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.