FORMULA NOT WORKING

Anna Mullins · 02/05/19

HI,

I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue??

Please see attached excel with formula in Column D

Thank you in advance

Andrée Starå · 02/05/19

Hi Anna,

Try this.

=IF(NOT([email protected] = ""); [email protected] - [email protected]; TODAY() - [email protected])

The same version but with the below changes for your and others convenience.

=IF(NOT([email protected] = ""), [email protected] - [email protected], TODAY() - [email protected])

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Anna Mullins · 02/05/19

Hi,

I used

=IF(NOT([TOOLING DISPATCHED]2 = ""), ]TOOLING DISPATCHED]2 - [ACTUAL FOT]2, TODAY() - [ACTUAL FOT]2)

but I now get #UNPARSABLE??

Any Ideas ?

Andrée Starå · 02/05/19

It should work. try mine below.

Which country are you in?

=IF(NOT([TOOLING DISPATCHED]2 = ""); [TOOLING DISPATCHED]2 - [ACTUAL FOT]2; TODAY() - [ACTUAL FOT]2)

Best,

Andrée

Anna Mullins · 02/05/19

Still not working .... Im in the UK

Andrée Starå · 02/05/19

Can you share the sheet with me?

Share too [email protected]

Best,

Andrée

Anna Mullins · 02/05/19

Yes i can please please on work on column " Days since FOT" as the sheet is has important infomation in it

Shared

Brian W · 02/05/19

=IF(NOT([TOOLING DISPATCHED]2 = ""), ]TOOLING DISPATCHED]2 - [ACTUAL FOT]2, TODAY() - [ACTUAL FOT]2)

This formula has a backwards bracket. Could that be the problem? Try this:

=IF(NOT([TOOLING DISPATCHED]2 = ""), [TOOLING DISPATCHED]2 - [ACTUAL FOT]2, TODAY() - [ACTUAL FOT]2)

Andrée Starå · 02/05/19

Brian,

Nice catch!

We solved it outside of the community!

Best,

Andrée

Anna Mullins · 02/05/19

Thank you all for your help!! ??

Andrée Starå · 02/05/19

I'm always happy to help!

Best,

Andrée

Hashim Mohd · 04/20/20

Hi,

The below formula was working earlier with the same data and was getting the results.

=SUMIF([Tentative Instructor]$1:[Tentative Instructor]$187, [NIIT Instructor]2, Duration$1:Duration$187)

However, it's not working anymore and giving me an error :#NO MATCH

What could be the reasons please?

Thanks,

Hashim

Andrée Starå · 04/23/20

@Hashim Mohd

Hi Hashim,

Strange!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post 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!

Explore. Ask. Answer.

FORMULA NOT WORKING

Comments