Jump to content
We've recently updated our Privacy Statement, available here. ×

Renaming blank fields

Dimitry Rogov

Recommended Posts

I have a column titled " Expiration Date" which is linked to an Excel file depicting expirations dates for certain contracts. Some contracts do not have an expiration date; therefore, they show up as blank fields in my dashboard. How can I rename the blank fields to N/A or TEXT format. It allows me to put a DATE value for the blank fields, but not a TEXT value.

Link to comment
Share on other sites


If your "Expiration Date" column has been imported as a Date column, you can only put valid dates in it.

If you don't need to use that data type (e.g. in order to sort in date order, or perform operations that are only possible on dates, like the various "Date and Time" functions), you could simply convert it into a string column instead, and then you can replace the missing dates using whatever text strings you want.

Depending on your use case, maybe having both variants would be an option - you could simply add a calculated column that is the string version of your column (e.g. using the expression "String([Expiration Date])") and display that column when it makes sense, and the original column when that makes more sense.


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...