Hi I'm trying to convert a formula to a column formula but get an error message

Hilbert Kok

I'm using below formula, what is wrong in it, anybody got a clue?

=IF(NOT(ISBLANK([Completion Date]@row)); 5; IF([Target Completion Date]@row >= TODAY(); 1; IF([Target Completion Date]@row >= TODAY(-14); 2; IF([Target Completion Date]@row < TODAY(-14); 3))))

Thanks Hilbert

Rudy Moons

Hi,

Same issue here even with simple formulas :

=IF([Strategic fit]@row = "Unknown"; 0; 3)

The formula gives a right result but fail to be used as Column formula

Tnx

Rudy

Andrée Starå

Hi @Hilbert Kok & @Rudy Moons

Strange!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Hilbert Kok

This is the message when I'm trying to convert the formula to column formula

Genevieve P.

Hi @Hilbert Kok & @Rudy Moons

Are you able to convert these to column formulas if you use a comma (,) instead of a semi colon(;)?

Ex, try this:

=IF([Strategic fit]@row = "Unknown", 0, 3)

Hilbert Kok

Hi Genevieve, i converted all semi colon to comma and get an error message #Unparseable

Hilbert Kok

Rudy Moons

Hi Genevieve,

Same over here.

The formula is working fine but won't accept to be a column formula.

If I change the ';' in to a ',' I get a #UNPARSEABLE error, when I F2 the cell Smartsheet replace the ',' with a ';' automaticaly.

Andrée Starå

@Hilbert Kok & @Rudy Moons

Where are you located?

Rudy Moons

Hi Andreé,

I'm from Belgium, so we use 1,25 and not 1.25 in all DAX languages we need to use ; and not , (Excel, PowerBI,...)

I assume that this is the issue ;)

Genevieve P.

Hi @Rudy Moons and @Hilbert Kok

Since column formulas are a new feature, I'm not certain if this is expected behaviour for formulas using ; instead of , - could each of you open a Support Ticket with our team so we can look into each scenario with you one-on-one? Please provide our team with screen captures and sheet names, if possible.

Thank you!

Genevieve

Andrée Starå

@Rudy Moons

No I don't think that's it because it looks correct.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hilbert Kok

Hi Andreé I'm working from the Netherlands, and we use the semi colon as seperator and a comma like in Belgium.

Andrée Starå

@Genevieve P & @Rudy Moons & @Hilbert Kok

Oh wow! I've missed the release of the Column Formula feature.

🤩

Genevieve P.

@Andrée Starå I think it will be officially talked about later today!!! But the Help Center article is live so I figured it was OK to discuss in the Community! 🤩

Andrée Starå

@Genevieve P Yes, I approve 😉

Btw. It doesn't work for me either. Maybe it's not "live" entirely yet.