Highlighted
ACraig
Level I

Re: Update column with values when another columns contains specific value

Hello,

This might be a silly question but when using this code do you use it by editing the formula of the column? I did it as a formula like this since I am not doing it based off of a missing value. I am trying to update my column Vendor so that when the column Label equals "MnDOT Est." the vendor equals "MnDOT". But it gives me a Column Vendor Formula Interrupted error with an Illegal Reference thing. It changes the ones to MnDOT but it just deletes all the others. I hope that makes sense.

  

For Each Row(
        temp = :Vendor;
        :Vendor = If( :Label == "MnDOT Est.", "MnDOT", temp);
);
Highlighted
txnelson
Super User

Re: Update column with values when another columns contains specific value

This code needs to be run as a separate script, not as a formula.
Jim
Article Labels

    There are no labels assigned to this post.