I've been trying to automatically copy a formula in excel with AppSheet when creating a new row and having some difficulty. The Forumla option in AppSheet works however it doesn't output the formula into Excel and just the value after the calculation. I would like the formula to show up in excel automatically and calculate from there.
If I copy the formula in excel and extend it to multiple blank rows then try and create a row in AppSheet it will automatically place the new row in excel after the ones with a formula in them.
Any help on this would be greatly appreciated.
Thanks,
LinkedIn
Twitter
