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

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

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
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!