Hello,
I am trying to define criteria within a PB (or flow I have tried both) where the criteria is if the year is last year. I have a year field on the object and have been trying a formula to remove one year from that but its not working.
Some of the options I have tried are:
TEXT(YEAR(TODAY()-1))
TEXT(yearfield_c)-1
The year field on the object is a picklist so I even tried creating a 2nd year field on the object that was a formula field and pulling the value from the first year field into this but it is still not working.
Any suggestions please? And thanks in advance :) #Process Builder #Flow #Formula Field
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi,
You would need something like:
Picklist - equals - formula - TEXT(YEAR(TODAY())-1)
Bear in mind that the API name of th epicklist values need to be the year exactly, it cannot be different to your label here