Hi, I have a formula that used to create an order number, composed from the following fields:
The date date + an auto number, then the "/" character gets removed.
Our vendor also uses Smartsheet. I have an automation set up to send the information over to the vendor, but it doesn't transfer right. It consistently transfers the Auto Number portion only.
Is there a way to change the "Order Number" column to just be a string? My guess is the formula is messing things up. Help is appreciated!
I won't go into the "matching" portion just yet.
