IF condition in Text field
Hi there, I have a [B!T Client Rating] Text field, it can contain numbers 1 to 5 or it can contain stars, so *, **, ***, ****, or *****. So I want to unify and convert the stars to numbers. I cre...
Forum Discussion
Try this
IF(
[B!T Client Rating] = "*", "1",
[B!T Client Rating] = "**", "2",
[B!T Client Rating] = "***", "3",
[B!T Client Rating] = "****", "4",
[B!T Client Rating] = "*****", "5", [B!T Client Rating])
If that does not work please post your formula and the complete error message.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
IF(
[B!T Client Rating] = "*", "1",
[B!T Client Rating] = "**", "2",
[B!T Client Rating] = "***", "3",
[B!T Client Rating] = "****", "4",
[B!T Client Rating] = "*****", "5", [B!T Client Rating])
If that does not work please post your formula and the complete error message.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks! it has worked!
------------------------------
Consuelo Viramonte
------------------------------
------------------------------
Consuelo Viramonte
------------------------------
