Why is an error message invalid data type generated for this formula (Please provide proper syntax)
Why is an error message invalid data type generated for this formula (Please provide proper syntax)?
=IF(AND([Start Date]@row <= TODAY(), Status@row = "Not Started", "Red"), IF(AND([End Date]@row <= TODAY(), Status@row = "Complete"), "Red", "Green"))
Answers
-
Proper syntax would be:
=IF(AND([Start Date]@row <= TODAY(), Status@row = "Not Started"), "Red", IF(AND([End Date]@row <= TODAY(), Status@row = "Complete"), "Red", "Green"))
However, that particular error message leads me to believe that either one or both of the date columns is not an actual date type column or the data within one or both of those columns is not a date value.
-
Is this a problem if I am using predecessors as both date columns have value dates and are date fields (e.g., Date/Time)?
-
What do you mean by "Date/Time"? Are you able to provide a screenshot of your sheet to include the column headers?
-
The Date/Time is the column property
-
Are you a part of the Early Adopter Program? If so, I don't believe that column type has been rolled out publicly yet. You may need to delete this thread and reach out to the EAP support.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!