
Announcements
I want to use excel on line in a sharepoint
this excel contains 2 sheets:
A first sheet named Input (fed by a powerautomate flow from Lists)
a second sheet Calculation (transfer of rows from the Input sheet) with excel formulas like Index /match but also addition
QUESTION :
The transfer of information between the Input sheet and the Calculation sheet does not work with index and match?
Is it necessary to set up a powerautomate script for the transfer between the two sheets?
thank you for your help
Translated with www.DeepL.com/Translator (free version)