Auto format formulas

Scott_L · 09-29-2021 12:19 PM

any tricks for auto formatting a formula in the Formula editor?

MultiTech

What do you mean?

Scott_L

Code editors often have a way to format code into something more legible. Taking something like

SeLeCT(Territory[OriginalCountry],anD([OriginalCountry]<>[Country],[OriginalCountry]<>[_ThISROw].[Name],[Country]=[_ThISROw].[Name]))

and reformat it to something like

SELECT(
Territory[Original Country],
AND(
[Original Country] <> [Country],
[Original Country] <> [_THISROW].[Name],
[Country] = [_THISROW].[Name]
)
)

Steve

Scott_L

hmm, I did actually start using that extension just today. (Highly useful, thanks Crew). But not seeing the formatting feature kick in yet …

Steve

I’m not aware of any tool that works as you want.