Dimitry Rogov Posted October 9, 2023 Share Posted October 9, 2023 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 More sharing options...
Fredrik Rosell Posted October 10, 2023 Share Posted October 10, 2023 Hello,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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now