You need to sign in to do that
Don't have an account?
timy teenu
checking consecutive numbers and updating field
I have field years donated its a dlrs rollup field. If there 5 consecutive numbers in the field i need need a sperate field Donor streak to be updated to be have value 1
so for example if year donated have value like say 1995; 2001;2002;2003;2004;2005
then I need Donor Streak to have value 1
but let say if years donated is 1995, 2014,2015,2017,2018,2019
then donro streak should have value 0 or blank.
is this possible with formulas? or regex
so for example if year donated have value like say 1995; 2001;2002;2003;2004;2005
then I need Donor Streak to have value 1
but let say if years donated is 1995, 2014,2015,2017,2018,2019
then donro streak should have value 0 or blank.
is this possible with formulas? or regex