- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Row column
What is the fastest way to get a column
New Column( "Row", Formula( Row() ))
1 click = 1 drag&drop = 1 key pressed
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Row cloumn
Created:
Jan 30, 2023 04:20 AM
| Last Modified: Jan 30, 2023 1:59 AM
(1261 views)
| Posted in reply to message from hogi 01-30-2023
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
-Jarmo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Row cloumn
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 ) ));
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Row cloumn
Seems like Character columns won't let you use Count which would do this when used with Group
-Jarmo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Row cloumn
Created:
Jan 30, 2023 09:07 AM
| Last Modified: Feb 2, 2023 5:01 AM
(1231 views)
| Posted in reply to message from jthi 01-30-2023
strange, isn't it?