IF/AND Statement using text & checkbox
Ok, I've got to be so close on this formula and it's probably something so simple I'm missing.
I want the cell to check the box if two criterion are met: The "In AOP" is checked, and the Status is "Temporary Replacement".
=IF(AND(FIND([Employment Status]@row, "Temporary Replacement), FIND([In AOP]@row, =1), 1, 0)
Best Answer

I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column.
If that's true, this should do it:
=IF(AND([Employment Status]@row = "Temporary Replacement", [In AOP]@row = 1), 1, 0)
Not sure why you're using "FIND." Are you trying to get a summary of ALL rows that have both "Temporary Replacement" and the In AOP box checked? If so, you could create a column that uses the formula I provided, then use the worksheet summary flyout to place a COUNTIF formula for that summary.
Answers

I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column.
If that's true, this should do it:
=IF(AND([Employment Status]@row = "Temporary Replacement", [In AOP]@row = 1), 1, 0)
Not sure why you're using "FIND." Are you trying to get a summary of ALL rows that have both "Temporary Replacement" and the In AOP box checked? If so, you could create a column that uses the formula I provided, then use the worksheet summary flyout to place a COUNTIF formula for that summary.

Yah it worked! That was driving nuts, I knew I was just a little off. LOL
Thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!