Skip to main content

I frequently need to take text and make it lowercase, and remove spaces. 

I was wondering if it was possible to do this in 1 formatter task instead of 2.

I thought a spreadsheet style formula would work, but it seems LOWER is not supported.

Is there anyway to do this in 1 step instead of 2?

Getting this: 

The app returned "Unknown Function: LOWER".

even though LOWER is a common spreadsheet style formula. 

A code or AI step can do it in one. 


I know this just seems like the kind of thing you should be able to do with a spreadsheet style formula. 


This is what’s available. 
 

https://help.zapier.com/hc/en-us/articles/8496181204877-Available-spreadsheet-style-formulas#formula-functions-0-0 


Got it thank you. It seems like they could use some more text transformation functions, what they have is mostly number based.  


@gwinig 

FYI: Formatter steps count as 0 Tasks in Zap Runs.
 

 


I am aware just think it would be a nice addition to have more text functions in formulas so you can do a multiple things in 1 if you want. 


@gwinig 

Feedback and feature requests can be submitted via a ticket to Zapier Support to be logged for future consideration: https://zapier.com/app/get-help