This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
JSL formula new column fill in sequence based on another column content
Created:
Jul 26, 2021 09:09 AM
| Last Modified: Jun 9, 2023 03:53 PM(1440 views)
could help to suggest how to use JSL formula to generate one new column "ID", and fill in sequence number from 001-00N.
if cell value is in list {aim_lio, yeah_hoo, CC_act}, new "ID" column auto fill in 001-00N. if cell value is in list {bb_yoon, lzh_hao, Ke_oh, he_low}, new "ID" column auto fill, and restart from 001, 001-00N'.
if cell value is in list {ge_green, Ye_kio}, new "ID" column auto fill, and restart from 001, 001-00N''. thanks a lot.