Autofill if a column contains vs. if true or false
trying to figure out if/how i can make a sheet auto fill a column based "if contains" not "if true"/"if false"
Ex: Door Schedule for production
Column to report on = Door Size
Reporting Column = Drop down of hinge counts
If "Door Size" contains "80"  Hinge Counts = 4
If "Door Size" contains "70"  Hinge Counts = 3
What would that Formula be?
Answers

Hey @zszostak
I'm assuming only the number needs to go into the Hinge Counts column and not the number + text. The formula should reside in the Hinge Counts column.
=IF([Door Size]@row="80", 4, IF([Door Size]@row="70", 3))
If "80" is the complete textstring in your Door Size column, you do not need to use the CONTAINS function. If the "80" is only part of the the textstring, ex; "80 partnumber ABC", then yes, you could use the CONTAINS function.
If you must use the CONTAINS function
=IF(CONTAINS("80", [Door Size]@row), 4, IF(CONTAINS("70", [Door Size]@row),3))
Let me know if you also need the text and I'll show you how to modify the formulas above.
Kelly
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!