How to have first cell in a time period as an input and subsequent time periods as formula

Hi,

I am looking to set the first cell in my time range as an input and the following time periods to be based on the first cell. I think I use the offset function for future years but I'm not sure what to do for the input.

Appreciate any help with this.

Tom

2022-06-01_16-45-38_138876.png

Accepted answers

Misbah

@tomflahavan

You can not have a formula and input in the same line. If you want first cell to be editable and follow up cells to be read only then DCA is the option but that doesn't help you because you want first cell to be editable and follow up cells to be calculated based off of first cell.

You will have to create two diff lines - one input and second calculated line

Hope that helps

Misbah

Miz Logix

All comments

Misbah

@tomflahavan

You will have to create two diff lines - one input and second calculated line

Hope that helps

Misbah

Miz Logix

M.Kierepka

Hi @tomflahavan,

I think it's not possible - even Brought-Forward (which adds such extra opening balance period) is not editable if you have formula.

I'd ask - why do you need such thing, if all your years will have the same value? Maybe instead you should do an input without dimensions (so only one cell), and if you need it for some calcs/report by year, just reference your input.

However, if you really needs this "look", you can create dummy years list, where every next year is parent of previous one - it will mean that you can only input at lowest level (first item), and every other is parent of previous one, thus having the same value (if you pick summary as Sum/Min/Max/Average).

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…