Formulas

dfortuna
✭✭✭✭
Good Afternoon...
We are building a sheet to include a column must have 1 of 4 different criteria can be met as well as a True/False criteria formula. When completing the form, the fields are not populating correctly and if you copy the formula down the column, it puts False in each field. What is the best way to get around the field not populating information in the column (or sheet) if you copy the formula?
Thank you!
Answers
-
Hello. Right click the formula cell and "Convert it to Column Formula" rather than copying the formula down.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 75 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!