I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a new column rather than the built-in Title column.
The relevant columns in this list are:
- [Date From] - Date/Time (Date Only)
- [Date To] - Date/Time (Date Only)
- [Created By] - User (built-in)
- [Caption] - Calculated (Text)
I took at look at some documentation and wrote the following formula:
=TEXT([Date From], "mm-dd-yy")&" - "&TEXT([Date To], "mm-dd-yy")&": "&[Created By]
However I'm unable to save it, with an error message:
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.
I expect the output to be for example:
10/14/2013 - 10/20/2013: John Smith
How do I make this formula work? I'm assuming that it's complaining about the "Created By" column, right? How would I get around that?