Formula that generates a serial number using data from other text fields, not numerical fields. Also need dashes in between info. Please see attached formula and data

  • 0
  • 2
  • Question
  • Updated 3 years ago
  • Answered
Formula that generates a serial number using data from other text fields, not numerical fields. Also need dashes in between info. Please see attached formula and data needed. 


Photo of Meme

Meme

  • 10 Points

Posted 3 years ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Create a formula text field and you can just use the same format as excel but instead of cell references like B13, you just put the field name in square brackets.

For example

[Field A] & "-" & [Field]

Use spaces for readability. They are ignored.
Photo of Meme

Meme

  • 10 Points
Thanks so much, works perfectly!