Hi Appsheet Community, I am having trouble to configure the formula for the Job No. Column..itshould start with SCW then current year - month when the job will be done then followed by the serial number. The month should follow the job date month…then if the month changes the serial no. should ret…

Hi @franc / @Steve / @Suvrutt_Gurjar / @dbaum Below formula worked :grin: …thank you all so much for your untiring help!! :heart_eyes: CONCATENATE( “SCW”, TEXT([Job Date /Time], “YY-MM”),RIGHT(“00”& (COUNT(FILTER(TRANSPORT TICKET,MONTH([Job Date /Time])=MONTH([_THISROW].[Job Date /Time])))+1),3 …

SERIAL NUMBER -- BASED ON JOB DATE

AppSheet AppSheet Q&A

Suvrutt_Gurjar August 24, 2022, 2:11pm 21

Okay, great. Nice to know that.

Topic		Replies	Views
Is there a way to keep sequential numbers of items in a column that resets on Jan 1st? AppSheet Q&A ux	7	31	November 13, 2021
appsheet formula AppSheet Q&A expressions	15	49	February 16, 2023
Concatenate invoice number AppSheet Q&A app-management , other , expressions	14	35	September 20, 2022

SERIAL NUMBER -- BASED ON JOB DATE

AI Suggested topics