sharepoint lookup columns and calculated columns

Question

how to pull over a calculated column as a lookup column into another list

Answer 1

I have done lots of test and reproduced the issue.

Here is a solution for you to solve this issue.

1.In the source list, there are three number columns and a calculated column.

2.In the calculated column, you need to set the formula as =TEXT(([number1]-[number2]-[number3]),"0") which makes the text value in a specific number format.

3.Results in the lookup column.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Here are steps:

1.Go to list A -> List settings -> Create column -> Create a calculated column with formula in the list A.

2.In the list B, Add column -> Lookup column -> Use calculated column in the lookup column.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Thank you for your help. While this solution kind of worked, my data is $currency type, so the number showed up with a lot of extra "0"s behind the decimal. I changed it from Single Line of Text to Currency, but then the data did not show up at all. Is there a way to get rid of the extra zeros?

Answer 4

Thanks for your reply.

To solve this issue, please kindly provide more information below to let us work further.

1.In the source list, whether the issued column is a calculated column?

2.If it is a calculated column, what is the formula in the calculated column? And what is the data type returned from this formula?

3.If it is not a calculated column, what is the type of the issued column?

You could provide some screenshots about the issued column.

Generally, to reduce extra zeros behind the decimal, you should change the issued column settings in the source list.

Go to source list -> list settings -> click the issued column in the Columns section -> Set Number of decimal places as 0.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.