Hello fellow community members,
I have a sheet (Sheet1) which has multiple columns - say ConfigValue1, ConfigValue2. Then I have a column called Result that calculates a result using those values and values (Logic1, Logic2) from Sheet2.
In Sheet1:Res...
nea_lpatil:
Does it show what you are describing ?
Yes, and this is the airtable solution. However, imagine I have 50 currencies, but then also localized transfer pricing. :slightly_smiling_face:
Bill.French:
I do not have a solution to...
I think the most reasonable comparison is this:
Sheet 1 is a sales forecast. Forecast values are all in different columns in different currencies.
Sheet 2 are currency conversion values.
Goal is to create a column in Sheet1 that converts all the diff...
Exactly Bill.
The parallel in Excel is a main worksheet and a separate worksheet with various “settings” that can be changed.
Main worksheet would reference exact cells such as SettingsSheet.$C$3.
Which means lookups and linked records isn’t applicab...
