Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 09, 2021 10:55 AM
IF({Deposit Collected} = 1, “Deposit Collected”, Total/2)
I want the last part of the formula (Total/2) to output a dollar amount with a dollar sign ($).
Right now it’s just putting out the number, it has the decimal point and everything. I can’t figure out how to add the $ sign in front of it so the output looks like $1234.50.
Any help is appreciated!
Feb 09, 2021 11:29 AM
There’s a formatting tab right next to the formula entry tab. Should let you do what you’re after.
Feb 09, 2021 12:15 PM
Thank you, but it doesn’t let me format this answer the way I’d like (actually it doesn’t let me choose ANY formatting because it says the answer isn’t a number :roll_eyes: ). That’s why I’m having trouble, I think I’m going to have to make the formatting part of the formula and I can’t figure out how.
Feb 09, 2021 01:38 PM
I should have paid closer attention to your formula. You should try to make the outputs of your IF statement the same type, if you want to use built in formatting. Try replacing “Total/2” with
CONCATENATE("$",Total/2)
Realize that this will output text in every case and you can’t rollup this column if you want to in the future. If you want this field to be a numeric format, think about what you can replace “Deposit Collected” with, in the 2nd part of the IF statement.
Hope this helps.