This formula worked a few weeks ago, but now ...

This formula worked a few weeks ago, but now it will only pull up the first value. (1 for Regular Time). The other values won’t pull up. I tried to reorder them and no matter what order, it would only pull up the first one. Additionally, when I put the “Time and a half” first, it gave me a Parameter 3 error. I do have the column set as a number column. Any thoughts? Thanks, in advance!

=SUBSTITUTE([Rate], “Regular Time”, “1”),

SUBSTITUTE([Rate], “Double Time”, “2”), SUBSTITUTE([Rate], “Time and a half”, “1.5”),

0 4 310
4 REPLIES 4

RezaRaoofi
Participant V

What column is set as number type?

RezaRaoofi
Participant V

Also the above formula seems like a section of a larger formula; how come those SUBSTITUTE(…) functions are comma separated with nothing else before/after them?! The whole thing ends with a comma?!

if it is a number column, I suspect you’d want something like:

SWITCH([Rate],

“Regular Time”, 1, “Double Time”, 2,

… )

@praveen Thanks, Praveen! That worked.

Top Labels in this Space