CCK Fields Cell References

Sorry for the late reply. For the time being, the cell reference syntax does not support multiple CCK fields. I turned this into a feature request.

Implemented the ability to refer to an exact field/item in any node. Here's the formula syntax:

="nid or node title/field machine name or label/item delta"!cellref

where field machine name or label is optional and defaults to first found sheetfield, and item delta is optional and defaults to 0.

What's missing is referring to other sheets on the same page.

How to reference to the current node?

Implement ability to refer to other sheets on the same page, using the syntax:

="field machine name/item delta"!cellref

where item delta is not optional. item delta is zero-based.

Note that you will need to get the latest code from GitHub in order to support this functionality.

Update: CCK sheet fields now accept titles. You can refer to other sheets on the same page using the syntax:

="field machine name or field label/item delta"!cellref

or

="sheet field title"!cellref

To be ported to D7.

Port to D7 pending this question: http://drupal.stackexchange.com/questions/30301/update-field-schema. Any help would be appreciated.

Done porting to D7.