Formula Smartsheet

Adilson Mota

Hello morning my friends

Sometime my Smartsheet showed the message attached and I need some suggestion about it.

What I need to do in my Smartsheet?

We have another solution about it?

Formula Smartsheet.JPG

Thanks and have a nice week

Paul Newcome

Your formulas are referencing too many cells. You will need to scale down your sheet, consolidate formulas, and/or if you are using VLOOKUP formulas convert them into INDEX/MATCH formulas.

Paul Newcome

Your formulas are referencing too many cells. You will need to scale down your sheet, consolidate formulas, and/or if you are using VLOOKUP formulas convert them into INDEX/MATCH formulas.

Adilson Mota

Excellent suggestion "using VLOOKUP formulas convert them to INDEX/MATCH formulas."

I will change the formulas according to your suggestion.

 Thanks

Paul Newcome

Happy to help. 👍️