Formula for number

Hi. so we create unique numbers for each location BUT the locations are submitted through three different sheets. is there a way i can create a formula so that no number is every duplicated on each sheet? also, can i auto generate numbers using all of the sheets?

EX: building, space, and department sheet each have one submission received and i want numbers to be 1,2, and 3 so that there is not three number 1s or 2s or 3s since they are separate sheets


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!