Is there a way in R12 to see a preview of the formula/function you're entering like the little box that was available next to the value formula box in R11?

Is there a way in R12 to see a preview of the formula/function you're entering like the little box that was available next to the value formula box in R11?

- 5 people found this helpful
If you already know this sorry, skip now, but if you don't here's what I've come across.

Like excel you can see formula detail in a pop-out window (the yellow box above the orange) This just gives you some detail of what all the fields in the formula are.

However, unlike Excel, I have yet to come across a "function helper box" (not sure what it is officially called ), like this:

I too think this would be helpful as it:

1) easily breaks out the fields for input (especially helpful for more complex formulas)

2) defines the formula objective

3) provides a preview/example of the output (all without saving)

So, if you're looking for a preview of an answer for a formula without saving, I don't believe it exists.

- 3 people found this helpful
Thanks Ben - it's the last line of your response that I'm after. In R11 you could click on the little cell-like icon and you could preview the answer for your formula but I can't find anything similar in R12.

Nevermind, maybe another enhancement request will come out of this

I've only used R12 so didn't even know the formula preview was a feature that previously existed. would be nice for it to come back!

- 3 people found this helpful
Hi Ben, Well it actually required extra steps... It just gave you a chance to see the results before you hit save, but it also required you to click preview before you could save. I liked it because it was a better view of my formula but now I feel like R12 gives me that better view and more formula help. Now, I feel like it's less steps just to click save and check your results below.

Here is what it used to look like, and you couldn't get out of this screen without previewing the results first.

In my humble opinion, the R12 interface gives me more formula help and a bigger bar in which to view my complete formula, and so I no longer need to preview the results.

- 4 people found this helpful
Hi Julie,

Yeah we don't really have that popup window in R12. I would say that has been removed because the interface now shows a much wider formula bar so you can see the formula more easily... of course in doing that, we did lose the preview option. However, the formula help is also more robust in that it will tell you if it can't find a particular table or column which it didn't do before. I feel like from a number of steps perspective, I can just hit save to see my results in the table below and make any corrections right away so I don't miss the preview.

- 2 people found this helpful
Interesting! Thank you for sharing Debbie Hagen. I'm all about simplicity and less steps!

Me too Ben Burkett! :-)