Excel Formulas

[dmanfra]

i have an excel workbook with many sheets that contain formulas which reference many other sheets and use many "IF" formulas.  What happens to those formulas and references when I import them to Caspio?

[Jan]

Hello dmanfra,

 

Welcome to Caspio Forum!

 

I am afraid, for now formulas are not imported, only values that are results of formulas.

There is the idea in the ideabox. You can add your comment to the idea and ask to add the possibility to import formulas too.

[dmanfra]

thanks.

[NailDyanC]

Hi, just to update and add in the previous comment above. Yes, as of now Caspio cannot import your formulas or calculations inside the Caspio table, only the results of it. However, what you can do is to translate or do the calculations in Caspio way. You may check this available functions that you can use in Caspio as your reference for your Calculations:  https://howto.caspio.com/function-reference/