Is it possible to get and R before my amount like this R 120.00 in my appsheet, and in Ontvang and kleingeld I can not get it to show 0.00 as it got IF(ISBLANK([Kontant]), “”, [Ontvang]) in ontvang and IF(ISBLANK([Kontant]) || ISBLANK([Ontvang]), “”, [Ontvang] - [Kontant]) in kleingeld in the “INITIAL VALUE”
Because you are using number columns, it won’t work. You would need to use text column for this, but not sure if it’s good approach in your case. Though if you need the number value somewhere else, you can always convert the text to a number.