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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!