How to reflect new columns from Existing Database table

[Anonymous]

Hi,

I have a database that has 2 columns (FWork Main Aim and Standard Title).

I'm trying to create a custom column that says if FWork Main Aim begins with Non reg, then choose the Standard Title, otherwise choose the FWork Main Aim.

I've got as far as

=IF(LEFT(TRIM([FWork Main Aim]),7)="Non reg","[Standard Title]","[FWork Main Aim]")

I keep getting syntax errors, so would appreciate a formula that would do this for me.

[Greg_Deckler]

Column=IF(LEFT(TRIM([FWork Main Aim]),7)="Non reg",[Standard Title],[FWork Main Aim])

[Anonymous]

I get the following error from that. It doesn't find any syntax errors (so much improvement on my attempt!), However, when I click ok i get the following

Expression.Error: The name 'Column' wasn't recognized.  Make sure it's spelled correctly.

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

The formula(M) below should work in your scenario. 

=IF(Text.Start(Text.Trim([FWork Main Aim]),7)="Non reg",[Standard Title],[FWork Main Aim])

Regards