# Changing field type for Closed lost reason

**URL:** <https://community.hubspot.com/t/changing-field-type-for-closed-lost-reason/113407>\
**Category:** CRM\
**Tags:** professional\
**Created:** [July 31, 2024, 4:06pm UTC](https://community.hubspot.com/t/changing-field-type-for-closed-lost-reason/113407 "2024-07-31T16:06:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![AFlaherty6](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@AFlaherty6](https://community.hubspot.com/u/AFlaherty6)\
**Post date:** [July 31, 2024, 4:06pm UTC](https://community.hubspot.com/t/changing-field-type-for-closed-lost-reason/113407/1 "2024-07-31T16:06:16Z")

</div>

When we first started using HubSpot we did not configure the Closed lost reason so it defaulted to multi-line text. Now we want to make it a dropdown but I can’t change it because it indicates it has a value in 418 records. When I look at the records there is no value in any of them, so I’m not sure where this is pulling from. Any assistance is appreciated.

 ![AFlaherty6_0-1722441900652.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/7/b7e158b82db81cc1a2db057fa7ce54508004f944.png)

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [July 31, 2024, 4:12pm UTC](https://community.hubspot.com/t/changing-field-type-for-closed-lost-reason/113407/2 "2024-07-31T16:12:07Z")

</div>

Hi @AFlaherty6,

Are you looking at an unfiltered view and are you sure that you have view permissions for all deal records? HubSpot typically doesn’t lie about these things - the most likely explanation is that you can’t see the records.

In any case, unless you’re okay with losing the historic information in the free text field, you could also simply create a new drop-down field and replace the old with the new on the deal stage settings.

Best regards!

---

<div class="post-metadata">

**Author:** ![AFlaherty6](https://avatars.discourse-cdn.com/v4/letter/a/b4bc9f/32.png) [@AFlaherty6](https://community.hubspot.com/u/AFlaherty6)\
**Post date:** [July 31, 2024, 5:38pm UTC](https://community.hubspot.com/t/changing-field-type-for-closed-lost-reason/113407/3 "2024-07-31T17:38:36Z")

</div>

Thank you for your reply. Yes, I am looking at an unfiltered view and am  
the admin on the account, so can see all records.  
I’ll keep researching.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [August 1, 2024, 5:09am UTC](https://community.hubspot.com/t/changing-field-type-for-closed-lost-reason/113407/4 "2024-08-01T05:09:28Z")

</div>

@AFlaherty6 could you share a screenshot of the “Used in” tab of the “Closed lost reason” property?

---

<div class="post-metadata">

**Author:** ![DSharma02](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dsharma02/32/89701_2.png) [@DSharma02](https://community.hubspot.com/u/DSharma02)\
**Post date:** [August 1, 2024, 5:06am UTC](https://community.hubspot.com/t/changing-field-type-for-closed-lost-reason/113407/5 "2024-08-01T05:06:02Z")

</div>

Hi @AFlaherty6 , You are seeing the unflitered view and still don’t see any data might be the roperty may have had values in the past that were later cleared. The system might still be counting these records as having had values at some point.  
What you can do is export (CSV file) all the data along with this property and then check if you can see the value there. Then create the drop down propert and import the data into that.  
Hope this helps!  
Thanks