Populate Value of Formula Field in Text Field


#1

I’ve searched through the forum, but can’t find a specific answer to this. I know in Excel you can have an adjacent column prefill with a value of another cell, not sure how to do it in AirTable.

Here’s what I’m looking to do:

I have 4 columns:
Column1 - LongText
Column2 - A Formula column that counts the characters in Column1
Column3 - A Formula column that pulls the value of Column 2 and I’m trying to push this value also to Column4 below
Column4 - A Single Line Text column where I want the value of Column3 to automatically show.

If I get this to work then the column4 value will show on the Form View (because it’s not a formula) and I will be able to see the number of characters used as I’m typing them in form view.

Here is the formula I have in Column3 so far, but I’m not sure what to enter to get the value to show in Column4.

IF(Column2 > 1, (Column2), (Column4))

So Column3 is showing the correct value from Column2, but nothing shows in Column4.