Spreadsheet Formulas and Calculating Return values In Instance.
Having a column with a SSF (SpreadSheet Formula), what is AppSheets behavior? I would like to have a SSF and appsheet run the calculation on sync (or before with an appsheet formula) and publish the calculated value for that row. “#VALUE!” is my constant return with SSF.
Am I able to remove the SSF and add an ASF (AppSheet Formula) for same instance calculation?
My objective is to have a column with a SSF calculated before sync, on data change. I had this as a result before using a VC (Virtual Columns) and hiding the original column, but I am attempting to shorten sync time and the amount of VCs.
What is a solution that has the lowest processing cost and immediate return of result? I have used VCs to replace my SSF columns returning the desired behavior, not sure how sync time was effected, having ~15SSFs to replace with VCs is undesirable. Would I replace all of my SSF with ASF, burdensome…