I have a list with broken down data that is aggregated to some kind of combined ID data format that references a certain file. (Say, there is a file called 123-1. I have a field then that stores "123" and another one that stores "1"). I also have a column that calculates some kind of numeric data field based on these columns in the list.
Prefix Core Suffix Combined
123 123 123 369
"Combined" is the column of interest of this post...
However, to my dismay, as I tried adding this column as a site column, it did not work. It appears that site columns cannot be added if the field is a number calculated field. Is that correct? Or did I miss something?
I also tried, maybe I can just create a calculated site column to make this work instead. But apparently, I cannot seem to reference any lookup site column in my calculated site column formulae when I tried creating a calculated site column.
Ultimately, I am trying to use the site column as a way to transfer data from a parent site to some child sites. I tried going with the approach of recreating all the data needed to calculate what I need in the child site, but I run into the same problem that the lookup column based on a site column in a child site is not allowed to be used in a calculated column within that list I created in the child site.
Any suggestions on a workaround? Thanks!!