Please note: This feature is currently in open beta and is available on all Premium or Enterprise plans.
Using the formula field, grant managers can build formulas to calculate, format or transform information provided by applicants or grantees on a form.
The formula field supports common formulas and functions found in dedicated spreadsheet software like Microsoft Excel or Google Sheets, so you’ll have the ability to do everything from cleaning or standardising data to performing complex financial, statistical and mathematical operations.
Simply add a formula field to a form, configure the field with the formula or function you’d like to use and Good Grants will automatically apply your formula to an applicant or grantee response.
You can choose to disclose the result of the formula to your applicant/grantee or hide the result altogether.
The formula used can reference one or more fields at the same time and is well suited to both simple and complex operations.
Here are two more examples of formulas at work:
Formatting text into proper case
Want to format names to all use the same case? You can apply the same functions found in spreadsheets to make that happen. For example, use the “Proper” function to make names appear with the appropriate capitalisation: proper({field}).
Determining percent of profit
Say your grants are collecting information about the commercial success of a grant application. Profit margin % is an important part of evaluating whether to support the application with a grant or not. Instead of getting your applicants to calculate the profit percentage, you could ask for costs and earnings and let the system do it for you. This would minimise potential human error.
Here we have three fields, one with earnings and two with costs:
To get the profit margin percentage, we include calculation to get the profit and then calculate the margin, all in one formula!
There are many improvements planned for this new formula field, including a formula field helper, but we’ve released it in beta so you can start using it straight away. Let us know what you think!