Ben SmithBen Smith
Ben Smith/
Number Range
Number Range
Number Range

Number Range

For
Cynthia
From
Facebook
Status
Done
Formulas
+
+
length
length
*
*
ifs
ifs
Share

Range

ifs(
	prop("Options"),
	prop("Options").length() * 4 
	+ " – " + prop("Options").length() * 5
)
Old Explanation
if(empty(prop("Options")), "",
If Options is empty display nothing, otherwise do the following.
replaceAll(prop("Options"), "[^,]", "")
Takes the comma-separated list of the options and uses replaceAll to remove everything but the commas.
(length( ... ) + 1) * 4
Counts the number of commas, adds 1 (for the final option that has no comma), then multiplies the total by 4.
format( ... )
Converts the number result to a string.
+ " – " + format( ... ))
Concatenates the above with an en dash and then the result of the same but multiplied by 5.
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!