The IF function is a feature that allows users to implement conditional logic to their calculated fields and text fields with automatic calculations. When applied, target fields can be assigned to return specific values depending on if a written conditional statement has been satisfied for not.
What Does the IF Function Look Like?
At its most basic level, the IF function can be written as a formula like below:
IF(field = value, x,y)
Users can also include several operators--AND, OR, NOT--in their expressions to incorporate additional branching logic, or use nested functions to layer conditional expressions in sequence.
For a general overview on the IF function, please refer to our help center guide here.
For a more detailed look on how to set these functions up, as well as a practice use case to see the feature in action, please check out the video below:
Have further questions? Please email firstname.lastname@example.org
About the Author
Customer Success Specialist at Kintone. Kevin is the primary contact for Kintone users with account-based inquiries and native feature questions. Prior to joining Kintone, he worked as a public elementary and junior high school english teacher for three years in Kyoto, Japan. His hobbies include playing badminton, golf, listening to music, and checking out cool cafes and restaurants.