How do I override drag-fill data from sequencing?

I have some phone numbers and addresses that I am dragging down to new rows using Smartsheet's drag-fill function, but it seems to change the last number in the phone number and the last number in the mailing zip code every time. How do I prevent it from auto-sequencing during drag-fill?

I tried the old Excel trick where you add an ' apostrophe in front but it either erases it immediately upon hitting enter, or it ignores it completely and keeps sequencing.

Best Answer

Answers