Hola amigos,

Por favor, su ayuda a corregir el siguiente error.

He preparado una hoja maestra a partir de varias hojas utilizando la función VLOOKUP . Estuvo funcionando bien todos estos días, pero ahora en celda se muestra como #CALCULATING se resalta a continuación.

**Translated to English via Google Translate**

Hi friends,

Please, your help to correct the following error.

I have prepared a master sheet from multiple sheets using the VLOOKUP function. It was working fine all these days, but now in cell it shows as #CALCULATING is highlighted below.

¿Cómo puedo solucionar esto?

How can i fix this?


  • MCorbin
    MCorbin Overachievers Alumni

    Most likely, you're hitting the Cell reference limit. This happens when the sheet that you're getting the data from has a lot of rows - and/or you've got formulas pulling multiple columns from a large sheet into your summary sheet.

    The easiest solution is to break your summary sheet into multiple sheets - let them calculate formulas for just sections of data, then combine them back together using a report.

    Here's a little more information on the Cell link limits:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!