Looking for your help, we have a project health column (red, amber, green) on our register that we are looking to trend week on week. Or to run a report on whats changed yellow to red or green to yellow for example. And no idea how to do that . I looked at automation and the trigger on has 'changes to' it doesnt allow 'changes from' and changes to'.
Hope this makes sense...and thanks in advance for any support you can provide!
Help Article Resources
Check out the Formula Handbook template!