➕ Formula

[#1]

It is soo useful, 

 the new *)   command in the New Formula Column submenu:

*) one of the helpful, new features in JMP18.

Basic mode can save you hours over the course of a week:
No need to 1) create a column, 2) add a formula, and 3) search for the input column.

Simply: create a formula column with the input column already in place 1+2+3.

This is not all, the developer added some cool features to control 1 and 3:

1) do you really want to create a formula column?
maybe just calculate the value - maybe just overwrite the previous values , e.g. to convert Å to nm:

3) for the input column - just select multiple columns and you will get a new menu which can be used to synchronize the formulas:

Part of it was already possible via Substitute Column Reference in the Standardize Columns menu:

The new way is MUCH more intuitive - and much more flexible.
Thanks!

[#2]

Quite a few of those features do not seem to be visible for me (preview, column sets, name prefix/group name). Are they possibly new features of JMP19 EA (if they are they shouldn't be discussed unless JMP has made the information public) or just dependent on how your table looks / has / you have selected?

[#3]

As mentioned in the post, they were added with JMP18.

[#4]

If there is one drawback, it's the similarity to the other  command in the main part of the column right click context menu:

The similarity of the entries makes it difficult for beginners to distinguish between both function.

From the positioning, it gets clear that both of them do completely different things:

1. 
   The one below Column Properties is intended to edit the formula of the current column(s)
   
   
2. 
   The one in the New Formula Column submenu is intended to add a new formula column, either by generating new column, or by adding them to the current column(s) .

NB: This distinction is not 100% correct.
When there is no  formula in the column and you click on , it adds a formula column.
When you select multiple column, [with or without formulas] and you click on  and then on 

the menu will open in  mode.

[#5]

---

@hogi wrote:

The similarity of the entries makes it difficult for beginners to distinguish between both function.

---

I have to admit, not just beginners get trapped : )
Not the first time that I deleted my entries while "rescaling" them - just because I chose the wrong 
Good that JMP provides an UNDO function!

If the 2  were different colors - or if the  was "Edit Formula... "and "Create Formula...", my autopilot might be able to tell the difference even when I pay less attention.
What do you think?

[#6]

Have you ever received this error message 

after clicking on 

?

The explanation:

If the fist column of the floating column set  is a formula, JMP uses this formula to start with ..  and shows the warning:

Just replace this entry and use the floating column set from the center of the menu: