I need to operate around 15-20 trips per day using different sized trucks round the year. I need to generate Unique Trip ID in googlesheet based on date, month, year, truck size, transporter and the number of the trip on the day. The trip IDs will be unique in the column and input in Column U. The available trucks size are L-23, L-20, M-18, M-16,S-14,S12,T-10, T-8. Truck size is input in Column S. Transporters are MLS, TLT and AHK which is input in Column T. Suppose, a trip with truck size, S-12, will move on 25th June 2022,Saturday and the Transporter is MLS. So the unique trip id will be MLS1225062201 where MLS is the transporter,12 is the truck size, 25 is the date, 06 is the month, 22 is the year and 01 is the number of the trip on the mentioned day.
For more, here is the link of googlesheet https://docs.google.com/spreadsheets/d/1LeeWIHomcnk_sPahLNJ8pXeDEz1tjSGEoQGa3ulxiKU/edit?usp=sharing
Is it possible to generate using google apps script or any other formula?
