If Nested Statements

Please review and let me know where I am missing the formula. We have a column named Locations and next is the Campus. There are six possibilities and then everything else is Fort Worth Campus.

I have tried using the @row and did not like that either.

This formula is in the campus column.


=IF([Location]1="Kansas City CORP 4501","Kansas City", 

IF([Location]1="Kansas City CORP 4515",Kansas City", 

IF([Location]1="California Division Office","SanB Campus",

IF([Location]1="Topeka - COB","Topeka Campus",

IF([Location]1="Topeka - GOB","Topeka Campus",

IF([Location]1="Topeka 4th Street Warehouse","Topeka Campus","Fort Worth Campus"))))))


Any help would be great...

Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!