IF

IF helps you return different results based on whether a condition is true or false in DBSheet formula fields. It provides the tools you need to build conditional calculations, combine logic with other functions, and have results update automatically, making your work more efficient and helping you accomplish tasks with ease. With IF, you can create a formula field, enter an IF formula in the editor, follow the documented parameter format, nest IF with other functions such as AND, and see calculated results displayed immediately and refreshed when source data changes or after data import. Whether you're testing formulas on small data sets, troubleshooting parameter or data type errors, or using formula results inside larger expressions, IF helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53