# If text is X in column then change it to Y **URL:** \ **Category:** Ask for Help\ **Created:** [July 20, 2021, 10:22pm UTC](https://community.glideapps.com/t/if-text-is-x-in-column-then-change-it-to-y/29358 "2021-07-20T22:22:58Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![jchimp](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jchimp](https://community.glideapps.com/u/jchimp)\ **Post date:** [July 20, 2021, 10:22pm UTC](https://community.glideapps.com/t/if-text-is-x-in-column-then-change-it-to-y/29358/1 "2021-07-20T22:22:58Z")
I’m having a little problem with “price” entry on my app. When I ask a user to enter a price (I set that column to numbers only) so they can only enter the number and then the currency follows and it works great. But if it’s free then I ask them to enter 0. But it wouldn’t look good having 0 and then currency after it when displaying the price. So is it possible to do something like: When price is 0 then change text to FREE ? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 20, 2021, 10:28pm UTC](https://community.glideapps.com/t/if-text-is-x-in-column-then-change-it-to-y/29358/2 "2021-07-20T22:28:47Z")
Yes, create an IF column. If the price is 0, THEN return ‘FREE’, ELSE return the price. ---
**Author:** ![jchimp](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jchimp](https://community.glideapps.com/u/jchimp)\ **Post date:** [July 20, 2021, 10:36pm UTC](https://community.glideapps.com/t/if-text-is-x-in-column-then-change-it-to-y/29358/3 "2021-07-20T22:36:55Z")
Interesting. This however will change the price column to show the number entered only without the currency (currencies only show in number columns)… Do you think it’s possible to show the currency in an IF column…? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 20, 2021, 10:52pm UTC](https://community.glideapps.com/t/if-text-is-x-in-column-then-change-it-to-y/29358/4 "2021-07-20T22:52:40Z")
You can create a template column of the price. That will “lock in” the value with the currency attached. Otherwise you could remove the currency from the price column and instead include the currency as part of the template. Then create the IF column the same way I mentioned above, but instead of returning the price column, you return the template value. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/if-text-is-x-in-column-then-change-it-to-y/29358/5 "2024-01-17T16:51:25Z")