Is anyone else having trouble with the Today function?
Hello,
The Today function is not working when included in a simple IF statement. It was actually working a while ago but now it is not working.
I tested it out by simply trying =IF(Cell@232="2",=Today(),"") but it would spit out #INVALID OPERATION.
I have even tried =IF(Cell@232="2",Today(),"") but it would spit out #INVALID COLUMN VALUE.
Can someone explain why the Today function is not working? Thank you.
Answers

Two parts on this:
1) Your first formula attempt should be =IF(Cell@232="2",Today(),"") omitting the = sign before "Today", this should clear up your invalid operation.
2) Make sure this formula is within a Date formatted column, this should clear up the invalid column value.

Hello,
Thank you for answering. I have tried that formula in my second attempt and made sure that it is in the Date formatted column. Unfortunately, the formula is still not working for me.

Something isn't quite right with the first bit of your formula... Cell@232 doesn't make much sense to me, the naming convention would be more like [Cell]232 if your column name you are referencing is named Cell.
Is the column you have the formula in a Date column?
Perhaps also take the quotes off of "2" as well...

Hello,
Thank you for answering. I'm sorry, I should have copied and pasted the formula directly.
Here is the exact copy: =IF([Task Name]@row=2,Today(),""
The formulas automatically have the @ symbol now. I am not sure of when this started happening.
Yes it is a date column. Is that the problem?
I have tried it both ways of with and without the quotes.
I am really stumped with this issue.

They changed the @symbol so that you can convert a formula to a column formula.
I'm actually pretty stumped as when I recreate this it seems to function just fine.
What type of column is the "Task Name" column? is it strictly numbers?

The column isn't strictly set to numbers or dates. The formula that I am trying to implement was previously working a few weeks ago but I am not sure why its not working now. Thank you for trying to help me.
The column is actually called "Finish" which represents finished dates.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!