Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
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...
I am trying to add conditions to my nested IF statement, but somehow it’s not working.
I want to extract musical key information from the end of file names. The information I am trying to extract is marked bold.
BRASS CHORDS DARK G
BRASS CHORDS DARK ...
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!