Forum Discussion

JBGyro's avatar
JBGyro
Regular Visitor
2 years ago

Possible to insert text in date column?

I have a date column that shows completed dates for projects, this is a data group to based off the actual date column so we can get the MMMM YYYY format. The blanks in this column represent projects...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

BLANK() is not the same as ""

JBGyro's avatar
JBGyro
Regular Visitor
2 years ago

Thank you for the reply. This helped as I changed my formula to:

 

Column = IF(ISBLANK([Finish Date]), "Active", FORMAT([Finish Date], "MMMM YYYY"))

 

This changes the column to Text, but now it is sorted alphabetically so there is more work to be done.