Hello All,
I have a requirement that Upload spread sheet and display in different screens. After made any changes to that particular fields need to download the spread sheet.
I have gone through all the process, HOWEVER my issue is with formulae. Uploaded spread sheet is having formulae and while downloading its coming as data (without formulae).
Could any one can suggest how to proceed with this. I need the downloaded spread sheet also should have formulae.
Thanks in advace.
Discussion posts and replies are publicly visible
We have seen this before where if you have a formula on a cell and then Appian writes to that cell, it 'removes' the formula. A way we got around this was to create another worksheet that has the formulas and just references the worksheet and cell that Appian writes to.
Just an idea!