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โ),
What column is set as number type?
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.
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |