How to Add Specific Field into Form with SUBSTITUTE Formula


Hey Community,

I am trying to have my OPPTY # field prepopulated in my form using the SUBSTITUTE formula because a lot of our users tend to enter it incorrectly. Can you please help me figure out how to solve this? I will paste a screenshot of the format below.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!