Skip to main content
Question

Formula to change one letter in a text field

  • April 11, 2017
  • 0 replies
  • 35 views
Hello!

I have a text field. This text field will always have "XXXX-XXXX" format, unless there is a revision to the document. In which case, it will turn into "XXXX-XXXX 01"

I was wondering if there is a formula to turn that "0" to "R", to signify revision status, without changing other "0"s?

This "0" will always be in the same 11th spot. 


Thank you for all of your help!
      This topic has been closed for replies.

      • ChrisChris
      • Quickbase Alumni
      • April 11, 2017

      [altered field] = formula text =

      Left([field],10)&"R"&Right([field],1)

      Terms & ConditionsAccessibility statement