topic Re: Row cloumn in Discussions

Row column

hogi — Sun, 11 Jun 2023 11:49:25 GMT

What is the fastest way to get a column

New Column( "Row",	Formula( Row() ))

1 click = 1 drag&drop = 1 key pressed

jthi — Mon, 30 Jan 2023 09:59:51 GMT

Toolbar/add-in/script with such a functionality. Or you can create initialized column after right clicking on the column header

Edit:

If formula is needed New Formula Column context menu should be able to do it

hogi — Mon, 30 Jan 2023 10:42:13 GMT

wow, initialized values - very useful!
always something new to learn :)

The approach via the right click new formula column menu is nice - 4 "clicks" (or mouse movements without clicking).

let's see if anyone can beat that.

By the way, there is no shortcut formula to count the entries in a column, e.g. the :name column, right?

New Column( "count",Numeric,"Continuous",	Formula( Col Number( 1, :name ) ));

jthi — Mon, 30 Jan 2023 13:25:20 GMT

Seems like Character columns won't let you use Count which would do this when used with Group

hogi — Thu, 02 Feb 2023 13:01:49 GMT

strange, isn't it?