Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Can someone help with the following function?

=IF(OR(COUNTIF(CHILDREN(), 0) > 0, 0, 1)), IF(OR(Status@row = "Completed", 1, IF(Status@row = "Executed", 1, IF(Status@row = "Secured", 1))))


They work separately, I tried to add in the "OR" to have a column function.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions