This article troubleshoots an issue where the writeback or attempt to save data in the portal is not saving completely, but it does in Excel. In Excel, the template saves the input.
If you have ignore flags and they have IF statements that bring back a “0” instead of a space, the storage will get ignored in the portal, but Excel does not consider the “0” an ignore flag. There have been suggestions that this may have worked in 4x, but this function is not supported within the 5x Web Portal – our web portal requires a blank to not ignore the storage
Replace the zero input with double quotes (“”). If you do run into a similar issue in the future, please double check the ignore flag formulas to make sure they show a “” when the data should be saved.
Private Host 5.x