Question

I'm a newbie and can't figure out how to get a comma added to this formula: ": " + format(prop("Views"))

Views is a number being pulled from YouTube API. When it comes into notion I have it set to display as number with commas. It looks like this: 1,000 But since it doesn't include a label of what the number is, I created another formula property "View Label" which you see above. But it doesn't bring the comma over. It looks like this: : 1000 Someone suggested I use replaceALL but no idea how to add it to the formula I've got.

Answer 1

Actually it is possible the tutorial I followed had them in there.
But thank you for posting because that made me go back and revisit the steps. Turns out the formula to get the comma is at the very bottom of the tutorial.

Here it is in case anyone else ever needs it...

": " + replace(replace(format(prop("Views")), "(\\d{1})(\\d{3})$", "$1,$2"), "(\\d{1})(\\d{3},\\d{3})", "$1,$2")

Answer 2

You are doing it correctly.

Commas in Notion formulas when you convert numbers to text are not supported at the moment. Hopefully Notion implements this in the future.