Autofill Formula

Miles Allison

Hello,

I have two formulas set up that will display a value whenever a date is entered into the first cell of each row. That being said, sometimes the formulas won't work when a new value is entered. I've made sure the formula column is locked so user can't type information over the formula. I've also deleted the blank rows so the auto fill will copy the formula from the above rows. Is this something that other smartsheet users have experienced?

Thanks,

Miles

Debbie Sawyer

Hi Miles

Are you certain that your formula captures all types of valid entry? Could you paste a copy of the formula that isn't always working here?

Have you tried turning the formula into a Column Formula? (Right click and select Convert to Column Formula) This will ensure that the formula is definitely present in new rows.

I'd be happy to help further if needed.

Kind regards

Debbie

Debbie Sawyer

Hi Miles

Are you certain that your formula captures all types of valid entry? Could you paste a copy of the formula that isn't always working here?

Have you tried turning the formula into a Column Formula? (Right click and select Convert to Column Formula) This will ensure that the formula is definitely present in new rows.

I'd be happy to help further if needed.

Kind regards

Debbie

Miles Allison

I didn't realize convert to column formula was an option. This helps a lot. Thanks!