Concatenate - Display field in different Date format
I need a field that provides the following output in the sheet below: 1 (2-Jan-2023). I do have all the components and basically I need to concatenate Nr. & the Start Date.. but Smartsheet keeps on changing this to the default format, despite my column format.
Sprint number is currently : =[Nr.]@row + " (" + DateFormat@row + ")"
Thanks in advance for any help provided
Help Article Resources
Check out the Formula Handbook template!