Appointment Number Generation
I am building a Project Management system to deal with a high flow of scheduling. Currently I have the system built using the auto number column type, however when it came to creating a copy of the row I quickly found that the system will not update that value when it is passed out to a separate grid and cleared of appointment specific data and passed back thus creating a duplicate Appointment Number (I cant clear that value). The work around I have developed is as follows: I have assigned each project a value at its time of creation (an initial appointment number) and each time I find a duplicate Project Number and Appointment Number another column will use a MAX(COLLECT())) to find the highest value within the Appointment Number column and add a set value to it thus incrementing the system by a given amount. The issue with this is that I have to reference the appointment numbers previously given to projects to collect the max value and now its a circular ref. Has anyone ever had any success with generating their own numbering system within Smartsheet?
Help Article Resources
Check out the Formula Handbook template!