Autofill Formula

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

Best Answer

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Answer ✓

    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

Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Answer ✓

    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

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!