ERROR - #CALCULATING

Options

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?

Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Options

    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:

    https://help.smartsheet.com/articles/2478811-scc-requirements-guidelines

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!