I am trying to solve the following problem.
I have thousands of registration numbers that always start with a “T” and are followed by 10 digits.
This is how they are delivered to me T3090728379.
But they all need to look like this T-309072837-9
which...
I have a formula that’s doing what I want it to do. But I’d like the field {ACTUAL VALUE} to be currency formatted like {EST. VALUE} - I’d also like to get a SUM at the bottom of this column, so I need it to be a number.
This is what I have so far....
If someone could help me with this, I’d be extremely grateful. I can’t figure this out.
This is what I"d like to achieve through a formula:
Most Track Titles have a name followed by a “space hyphen space” and a suffix.
I’d like to automatically dele...
I have an interesting problem. I need to create database-sort-friendly versions of names, where all definite and indefinite articles are dropped from the beginning of each name.
I came up with this formula:
IF(REGEX_MATCH(Name,'^THE'),
SUBSTITUTE(Na...
Users have been calling for a simple TITLE CASE / PROPER function since 2016.
And I know, there is @Bill.French’s wonderful script - Field Tweaker - that allows you to reformat a field as either UPPER, LOWER, or TITLE CASE.
Field Tw...
I think I just found the solution:
IF(STAGE="Executed", {EST. VAL.},"")+0
That allows me to format the formula field as a currency.
And all empty fields show up as $0, which is perfect.
kuovonne:
TRIM(REGEX_EXTRACT({TRACK TITLE}, "[^-]*"))
Thank you so much, kuovonne.
Would you mind adding your line of code to my formula? When I try to do it, I get formula syntax errors.
Thank you!
