I have a column that is the key for my employee table. It is not a reference but a number field.
I have a vc that is a ref to my employee table whos formula is TEXT([Emp_ID]). This doesn’t seem to work cause I get the warning symbol and don’t have my label.
Use CONCATENATE([Emp_ID]) or ([Emp_ID] & "") instead.
Why does that work? I’m assume that does a different type of converting to type text than TEXT()?
TEXT() formats the value, which includes adding thousands separators for Number values. CONCATENATE() doesn’t format anything, it just puts it straight to Text as-is.
For instance:
| Value | TEXT() | CONCATENATE() |
|---|---|---|
1234 |
1,234 |
1234 |
1 Like
gotcha! figured this had to be something silly
1 Like