Pulling a value from a field utilizing an IF statement
I am trying to complete a formula, and am getting an invalid column value, however. Can you help?
Trying to have the formula look at a Revised Due Date column and if it is blank to pull the Due Date column value. If it is not blank, pull the revised due date column value.
=IF(ISBLANK([Revised Due Date]@row), [Due Date]@row, [Revised Due Date]@row)
Best Answer
-
I tested you formula before looking into a possible solution and it worked on my end. Invalid column value could mean that the column containing your formula is not set to "date" type column.
Try adjusting the column properties and see if that works for you.
Have a great night!
Answers
-
I tested you formula before looking into a possible solution and it worked on my end. Invalid column value could mean that the column containing your formula is not set to "date" type column.
Try adjusting the column properties and see if that works for you.
Have a great night!
-
I changed the property of my column to a date restriction and it worked! Thanks you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 286 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!