Formula column to autofill in a sheet populated by a form
Hello,
I'm an avid Excel user but new to SS; I'm hoping this is doable.
I have a sheet that is populated by a Form.
I've added a new column to that Sheet to display Month/Year from the Date column
Formula is =Month([Date]@row)+"/"+Right(Year([Date])@row),2)
I'd like for this formula to auto fill as rows are entered from Form submissions.
Best Answer

Hey @BrianDN
No, the Column Formula will automatically autofill your formula. Instructions are listed in the reference below. Essentially right click in the cell containing the formula and choose Column Formula. Note to edit a column formula you must open the cell menu and choose edit column formula.
Kelly
Answers

Hey @BrianDN
Yes, this is very doable. The build on your current formula is rearranging two inadvertently misplaced parentheses
=MONTH(Date@row) + "/" + RIGHT(YEAR(Date@row), 2)
Will this work for you?
Kelly

Hi Kelly,
Wow thanks for getting back to me so quickly!
Yes, that does give me the result I want for the row, however, I'd like it to auto fill as submissions come in.
I'd used to excel tables auto filling the column when new rows are added.
What action do I need to take? Do I simply drag the formula down past all of the rows with data? For now the dataset is small at 50 rows, but it will potentially have thousands... Do I need to drag the formula down to lets say row 50,000 to accommodate all potential rows? Or is there a way to make it fill automatically?

Hey @BrianDN
No, the Column Formula will automatically autofill your formula. Instructions are listed in the reference below. Essentially right click in the cell containing the formula and choose Column Formula. Note to edit a column formula you must open the cell menu and choose edit column formula.
Kelly

Perfect; thanks Kelly
Help Article Resources
Categories
Check out the Formula Handbook template!