The field two fields up is a lookup. I did it that way setting the value and it didn't work. I did that yesterday. That should've worked because the fields are setup exactly the same way. This is really crazy! Am I in Whoville????
I tried something different this time. I changed my field in the target list to a lookup field. I still have the source field being saved in the variable as Lookup Value (as Text). But this time I got a different error. It was: "Create Site Specific Item Activity Invalid data has been used to update the list item. The field you are trying to update may be read only."
It is crazy! Now no matter what I do, I get the same error. It is like the workflow is corrupt or something. I've taken out my code I added and I still get the error. I feel like I am on Candid Camera!!!
Update.....we have found out it isn't the FY lookup field that is causing the problem. Apparently this workflow has been erring for some time now. It is the lookup above the FY field. I knew it couldn't be the FY field because I took it out and was getting the same issue. That field is setup as a calculated column in the source list. In the target list field it is setup as a number field. Can ya'll help me out please?
Is the other field, other than FY also a lookup list column? If yes, then do that also in the same way or remove that from Create Item action and try.
I mentioned this in my comments earlier. What is the output value of the calculated column? is it Single line text or number?
This is what I tried for currency field to be populated into Number field. Select the return type as Formatted Currency else the default is String type which you cannot save into Number field.