Hi @Chandrasekhar_D ,
As of today it is NOT possible to write formulas with cross-workbook references. However, given your requirement will request you to explore Relationship fields & Lookup/Rollup fields in SSDC.
More details in this thread
1 Like