The scenario seems feasible. The cells that contain formulas are automatically updated when the referenced cell values are updated. You can read more in the Cell References
help article. For custom functions, the Custom Functions
documentation article or CustomFunctions
SDK example may help.
Get quickly onboarded and successful
with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.