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”),