FORMULA NOT WORKING

Anna Mullins

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å

Hi Anna,

Try this.

=IF(NOT(E@row = ""); E@row - C@row; TODAY() - C@row)    

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

=IF(NOT(E@row = ""), E@row - C@row, TODAY() - C@row)

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

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å

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

Still not working .... Im in the UK 

Andrée Starå

Can you share the sheet with me?

Share too andree@getdone.se

Best,

Andrée

Anna Mullins

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

Shared 

Brian W

=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å

Brian,

Nice catch! 

We solved it outside of the community!

Best,

Andrée

Anna Mullins

Thank you all for your help!! ??

Andrée Starå

I'm always happy to help!

Best,

Andrée

Hashim Mohd

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å

@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, 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 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!