Feature Requests

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.

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 .

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

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.

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.

If it will be possible to make a more complex script in a formula it may help

When building a formula to create a URL that prefills a linked field in a form, it would be handy if there was a function that would yield the name of the field. Field_Name[name of linked field] --> text of the name of the field. Note the attached image.

As the Workspace Administrator or Solution Manager I would like the ability to create a formula so that I can format a date as text Acceptable Criteria (ex. date = 01/03/2022) text syntax should allow for one digit format month and day (m, d, = 1, 3 text syntax should allow for two digit version for month day and year (MM, DD, YY = 01, 03, 22), including leading zero text syntax should allow for three digit format for month and day( MMM, DDD = Jan, Mon) text syntax should allow for four digit format for Month day and Year (MMMM, DDDD,YYYY = January, Monday, 2022) Text Syntax should allow for any order or combination of day, month year and punctuation Examples: 01/03/2022 Text(Date,"MMDDYYYY" = 01032022 Text(Date,"YYYYMMDD" = 20220103 Text(Date,"MM/DD/YYYY" = 01/03/2022 Text(Date,"MMM DD, YYYY" = Jan 03, 2022