Limit to Multiple Formulas-All IF statements.

cwerkley

Can you help me write a formula that has 10 different conditions and references multiple columns on the same smartsheet? I've utized the AI tool to assist me but when I get to the 7th formula, it cannot compute.

Kerry St. Thomas

My suggestion when trying to create complex formulas like you describe would be to start with helper columns and break your complex formula into component parts. Create your helper columns as type Checkbox. In each of your helper columns, create a column formula that's basically
=IF( [[ Condition 01 formula ]] , 1 , 0 )

Then it's a little easier to do your combined formula in one last column using whatever logic your specific use case may be:
=IF ( AND ( Condition01@row = 1 , Condition02@row = 0 ), 1 , 0 )

I suggest doing this instead of layering it all into one giant single formula. The benefit of doing it this way is it'll be more scalable (in the event any of the logic changes as your business evolves, or in case you have to add more on top of the existing logic), and if a data anomaly or whatever causes the formula to break it'll be easier to trace back and troubleshoot the components. Of course, do consider the capacity of your sheet when using helper columns.

Good luck!