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.