Form Template Issues
Has anyone had issues with cell reference links breaking in Input Forms after clicking Submit Sheet?
Background: We plan to base level accounts, with our operating expense accounts planned between...
Forum Discussion
Those posted in reverse order. Bottom picture I’m showing which department the 611000 base salary account I am planning and this is prior to submitting sheet. The picture with “100” shows that Dept_100 loaded correctly and retained the cell link. The picture with the “X” shows the cells became hardcoded for Dept_200, Dept_300, Dept_400
Hi Aric,
I think I get it now. This is about Excel behavior combined with the add-in rather than the form itself. I’d suggest opening a ticket with OneStream. Maybe it’s a bug or maybe there is an underlying cause they can help identify.
Thanks,
Andy
- Thanks Andy. I’ll follow back up on here once we get this issue resolved. Maybe it’ll help someone else out in the future!
This is a linked Cube View in Excel, yeah? If so, check the Cube View settings as well. There is an option to "Retain Formulas in Cube View Content"
Did you get to a resolution with OneStream on this? I'm seeing the same behavior, but for my specific process we have 7 CubeViews involved. 6 of the 7 keep the formulas as expected, but 1 of them lose the formulas on refresh/submit. I have not found what makes this one different then the others.
StephD we ended up creating a template using XFSet. Our users wanted to be able to link their forecasting models to the OneStream upload template using SUMIFS formulas. All of the XFSet logic is hidden/locked from them. All they have to do is work in their models and when ready to submit, login to the excel add-in and click submit sheet. Another reason we went with XFSet is the issue when rows shift in a cube view, such as a new GL account added during the year, it can easily break an end user's links to other tabs in their workbook.
