List Calculated Field with table reference
Hi, in a SharePoint List, I need a calculated field, and I wonder if it’s feasible with just JSON. Users already input: location (drop-down list) & year. Based on those 2 values, I input manually a labour rate, using a reference table. Is it possible (without transtionning to PowerAutomate) to have a calculated field spitting out that labour rate? Would a very long list of ‘if statements’ work?
Hi, in a SharePoint List, I need a calculated field, and I wonder if it’s feasible with just JSON. Users already input: location (drop-down list) & year. Based on those 2 values, I input manually a labour rate, using a reference table. Is it possible (without transtionning to PowerAutomate) to have a calculated field spitting out that labour rate? Would a very long list of ‘if statements’ work? Read More