Feature Requests

Global variables or records in table that I can retrieve using formula. Something like function "GET_LIST" but without having to link to other record. Example - I have a table of FX rates for a specific month and I need to use a combination of functions to filter out the correct FX rate, but without having to continually link the FX rate to the record that needs the FX rate calculation.

format formula fields like in airtable: Format and decimal precision: See image

I greatly appreciate the platform's flexibility and powerful features. However, I've noticed a feature that could significantly enhance our data manipulation capabilities—namely, the inclusion of regex (regular expression) functionality in formulas, similar to what's available in Airtable. Regex is incredibly useful for finding, replacing, and extracting specific character patterns within data. This functionality would allow users to perform complex text operations directly within SmartSuite, such as searching for specific patterns, replacing text strings, and extracting information from larger text blocks. These capabilities would streamline workflows and increase productivity by making data manipulation more precise and efficient. I believe this addition would be a valuable enhancement for many users, myself included, and I would love to see it implemented in future updates.

This could be a killer, missing feature in SmartSuite. Create a new function to be used in formulas that provides the ability to lookup and return data in a different application based on field data in the current record where the formula is being used. Syntax example: LOOKUP([Current_App_Field],[Solution].[App].[Field],) The formula instructs SmartSuite to look in the specified app for a matching value from the specified field in the current app, and then returns the value in the specified field in the app to which the function is told to lookup a value. This could emulate linking without having to manually link records or create an automation to do the linking. Would be very valuable. Requirement is that lookups probably could only be performed against fields where unique values are required (as in primary keys) or you would have multiple record matches.

Many SmartSuite users are not from the US, but the DATE_FORMAT() formula only allows dates to be formatted in the MM/DD/YY format, instead of in DD/MM/YY.

Functions library needs a lot of love, but this I think should be top priority: a way to insert a line break in the text result of a formula. Can be done in many ways, e.g. a LINEBREAK() function could work. FileMaker defines the pilcrow ("¶") as a literal with this value, but most people don't know how to type a pilcrow. Airtable uses "\n" and this is widely used elsewhere (e.g. in regular expressions). Given number of people coming to SmartSuite from Airtable, perhaps that's the best approach.

It would be extremely useful and simplify a great deal of our process to be able to have the formula field formatted as an “Assigned To” field, complete with interactions with statuses / due dates; as well as to be able to format it as a “Due Date” field, again interacting with Assigned To and status fields. Right now I handle this process by using a formula to select the correct individual based on earlier criteria, then using an automation to transfer that value to a linked record since “Assigned To” will not take a formula output, and then another automation (which has to be done as a separate automation trigger, as putting them in the same automation produces inconsistent results due to timing) will take that linked record field and transfer it to the Assigned To field so that the formula output becomes officially assigned to the task and it shows up in their My Work / allows them to be filtered based on Current Member. Similarly, I use lookup tables to pull in various dates, then when those change I adjust the due date for the tasks based on what phase of the project they are in using automations– that way I don’t need to have six different due date columns, six different status columns, and six different assigned to fields that are all configured with different viewing / editing permissions. If the formula field could be used directly as an Assigned To or Due Date field, it would cut the workflow to ~30% of the current process and eliminate 2-3 automations per instance. There's a similar request that @Stoyan commented on in July for Number formatting enhancements, but I did not see any mention of different behavior for Assigned To / Due Date connections.

For any users in the financial, mortgage, insurance, or real estate industry, the Excel formulas PMT and IPMT are important ones to have. Unfortunately, there isn't currently any work around to calculate amortized payments without using PMT .

I created a formula field with the formula "NOW()". In workspace settings, I've correctly indicated that I and my other users are in the United States/Central Time Zone (Chicago). Right now it's 3/17/2023, just after 10PM. But when I reference that field in an automation to put a timestamp in another field, SmartSuite ignores my workspace setting about time zone, and converts not only the time but the date as well to GMT. Again, right now for me in Texas it's 3/17/2023 10:00PM. But if I trigger that automation right now, it will say it's 3/18/2023 3:00 AM (= GMT-5). NO NO NO. I'd add that in my automation I first tried to use the System variable for Today. That has the same problem.

Airtable has this feature, and it solves for me having to take the % score and update the percentage progress bar. Currently we do this manually to update the progress bar.