Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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
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
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 ?
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)
Andrée
Still not working .... Im in the UK
Can you share the sheet with me?
Share too andree@getdone.se
Yes i can please please on work on column " Days since FOT" as the sheet is has important infomation in it
Shared
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)
Brian,
Nice catch!
We solved it outside of the community!
Thank you all for your help!! ??
I'm always happy to help!
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
@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!
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!
Hi all! I'm working on a column formula that will check whether the Column2ref cell in the current row is blank. If it is blank, the formula finds the maximum value in the ID column where the Trainer Name matches the Trainer Name cell value in the current row and the ID cell value is less than the ID cell value in the…
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
