+ Start a Discussion
Christina Lam 7Christina Lam 7 

Text Field with Number Formula Field + Process Builder

Hi All! Currently I have an AEBase Field called "Year Built" locked in as a Text Field.Ideally, I would like to use the "Year Built" field in a Number "Formula" Field, but the formula appears to not accept the "Year Built" field because it is a text and not a number field and it also appears that the Year Built text field cannot be deleted. Do you have any suggestions on how to get the data from the text field to go into a number "formula" field? 

An idea that I was thinking about was to possibly to create a new Number field to mimic the Year Built text field, automate the Year Built "text" field to  connect with the Year Built "number" field using process builder and then use the number field in a number formula field? 

It would be great to get some feedback on this, I appreciate it!!