Formula column to autofill in a sheet populated by a form

BrianDN

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.

Kelly Moore

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.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas#:~:text=With%20column%20formulas%2C%20you%20can,all%20tasks%20in%20a%20project.

Kelly

Kelly Moore

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

BrianDN

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?

Kelly Moore

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.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas#:~:text=With%20column%20formulas%2C%20you%20can,all%20tasks%20in%20a%20project.

Kelly

BrianDN

Perfect; thanks Kelly