Chris_Hamoen - profile

Chris_Hamoen · Aug 26, 2019

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...

Chris_Hamoen · Aug 30, 2019

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...

Chris_Hamoen · Aug 29, 2019

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...

Chris_Hamoen · Aug 28, 2019

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...

User Statistics

User Activity

Calculating a value in table one from values in table 2

Re: Calculating a value in table one from values in table 2

Re: Calculating a value in table one from values in table 2

Re: Calculating a value in table one from values in table 2