Formula Question
Hello,
I have a scenario where I want to build in an If AND formula and just am not too familiar with how to set it up.
I want to set it up as follow:
If someone's age is >= 55 AND their tenure is >=10, I want the column to state yes. If it does not meet this criteria, I would like it to say No.
Could someone help me set this up?
Thank you!
Tags:
Best Answer

Try an =IF(AND()) formula:
=IF(AND([Age]@row>= 55, [Tenure]@row >=10), "Yes", "No")
https://help.smartsheet.com/function/and
Answers

Try an =IF(AND()) formula:
=IF(AND([Age]@row>= 55, [Tenure]@row >=10), "Yes", "No")
https://help.smartsheet.com/function/and

Thank you Will, this worked perfectly.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 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!