Trying to expand my knowledge of writing formulas
Im having a little bit of a hard time trying to make formulas longer and saving column space(s). For instance when I run into an issue of creating a formula in 1 cell i sometimes create a new column and put the formula I wanted to add in there.
This takes up space which can be free'd up and when the sheet gets over 1000 rows long it eats up the smartsheet. I have looked at the smartsheet formulas reference sheet and I am just not sure how to add to an existing formula to make it work the way I want it to.
I'm using a formula that looks like this =YEAR([example]1). I want to add an iferror to it, so if it errors it will give a value of 0 back. (Which is where I would make a new column called
Help Article Resources
Check out the Formula Handbook template!