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
Check out the Formula Handbook template!