ProductSolutionsTemplatesResources

FORMULATEXT

Returns the formula as a string. Learn more.

Video field
Lookup

FORMULATEXT(cell) is a function in Google Sheets that returns the formula as a text string from the given cell. This means that if you apply this function to a cell that contains a formula, it will return the text of that formula rather than the result of the formula. The syntax for the function is straightforward - you simply specify the cell you want to retrieve the formula from, like this:

FORMULATEXT(A1)

In this example, if cell A1 contained a formula such as "=SUM(B1:B10)", then the FORMULATEXT function would return the text string "=SUM(B1:B10)".

This function can be useful in a variety of scenarios, such as when you're troubleshooting a complex formula or trying to understand how a certain calculation was made.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!