Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create an if statement that evaluates multiple Firstsorted values.
To simplify lets say I want to evaluate when the most recent [Status] is 'Pending' and the most recent [PendingDate] is equal to or before today. Also I cannot do this via a script, so I'd need an expression. I've gotten it work for each criteria, but when I try to include both it stops working.
First post so hopefully I'm in the right place and given everything I need.
please post some sample data and your expected result.