so i have data that runs till column 5 but that can be change every month, so sometimes can be in column 3 or column 4. i want it to capture the last column with any values.i need help. so i try to use the multi field formula and then do "iif (isempty([name]),1,0)" and find the last column however it returns everything false. i want it to know before F5 is true.i need help.
.
In this case, I recommend Transposing your data so the last record can be identified in the records. The attached workflow provides an example of this.
