Hi,
I have an action that works good. I added a column that contains an "IF" formula based on adjacent cell. I have the formula set up in the ListAppend. The formula shows up in the export spreadsheet (column F), but it doesn't execute.
This is the statement in the ListAppend: "=if(e"+RowNumber+"="""",today(),e"+RowNumber+")"
This is what it looks like in the exported spreadsheet:
If I click on it in the formula line of excel and then enter it will execute:
Is there an Advanced Excel server action that I can use to make the formula execute properly in the exported excel?
Thanks,
Glenn
Hi Glenn.There is an action, SetFormulaByName, that might help you.
Hi Beatriz,
Thanks for the reply and advice. I had tried the SetFormulaByName but it only affected one cell. I didn't think it would work for my needs, but I was using it wrong.
I then placed it in the "For Each" loop with the formula I had in the ListAppend and it worked.
Hi Glenn
You have some options to calculate the formulas before downloading the excel file.
Hope this helps.
Hanno
Hi Hanno,
Thanks for the reply. I tried the Worksheet_Calculate with the settings I had and it didn't seen to have any effect on the exported file.
Then I revisited the process with the SetFormulaByName in a different part of the action and things worked.