Using EDT for validations from previous column value

I am trying to create a validation to check if DS either remains or auto increments by 1 only, so in below case Row#5 is wrong

Template Task Name TS DS
Provide contact list to EA 01 01
Add contact Number to Director Phone 02 01
Fill the onboarding Form 03 01
Introduction to reporting manager director rani madam 04 02
introduction of organization 05 05
Provide Email ID 06 03
provide Punching & HR1 Login 07 03
Any traning session of QB if needed 08 04

PS I had 2 more validations , by the time , I wrote this post , i figured them out lol - writing does help

Offset is one way to do it.

image

validate.transform (3.4 KB)

1 Like

Offset is excellent !!! Thank you