Include ALL excel functions in SmartSheets

Hello,

I spoke to a very helpful representative who was trying to help me extract ONLY the data that follows the "[A]:" below that pulls into one cell of the SS:

[Q:] What is your age? [please list age] [A:] 85

I figured out that the following formula works when you export the data into Excel but does not work in SS because the function does not exist:

=TEXTAFTER(A1,"[A:]")

Can we improve SS to include ALL the excel formulas so this function (and many others) can function in SS? Thank you!

Sign in to vote!

Find more posts tagged with

Formulas

Idea Submitted

Comments

Adrian Mandile CHESS

Hi @Andrew.Frisina,

Generally, I agree that there should be more Excel-like functions available in Smartsheet.

However, some of the newer Excel functions are simplifications of older ones.

In your example, you could achieve the result of "85", by using existing functions as follows:

=SUBSTITUTE(QuestionAnswer@row, LEFT(QuestionAnswer@row, FIND("[A:]", QuestionAnswer@row) + 4), "")

bgummin

I find it much easier to work in Excel for formulas because they are simpler. One example for textafter use is getting the domain from an email address. Excel is easy: "=TEXTAFTER(B9,"@")" The Smartsheet solution is long and hard to figure out. I kept getting errors. Luckily, we just upgraded to Enterprise and I was able to use AI to generate: =MID(Email@row, FIND("@", Email@row) + 1, LEN(Email@row)).

Quick Links

Trending ideas

Automations Tracker
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Timeline Widget - Custom Colors
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
Activating & Deactivating automations
It would be nice to be able to deactivate all automations at one time when I need to work on a sheet. Then to be able to activate all of them at one time when I am finished. One of my sheets has 48 automations. It is extremely time consuming to deactivate them one at a time. Thanks! Freda