Options
Dennis Hoshield ✭
06/22/20 in Smartsheet Basics
I've created a sheet, with associated form, and things are working well.
I indented a row, to create a hierarchy, but don't see the +/- sign on any column, identifying it as the 'primary' column.
How can I ID the primary column? I will eventually want to use a client/contact name as the primary field/column, and it looks like I can copy the contents of the client/contact name to the primary field.
Bottom line, is I'm looking to create log entries for each client, indented under the appropriate client name
0 · Share on FacebookShare on Twitter
Brandi Cavender ✭✭
06/22/20 Answer ✓
Options
The primary column name will always be bolded. When you create a new sheet the column name will be primary column. The primary column can only be a text/number column.
5 · Share on FacebookShare on Twitter
Dennis Hoshield ✭
06/22/20 Answer ✓
Options
I don't see a bold column name. Is it initially a hidden column?
0 · Share on FacebookShare on Twitter
Paul Newcome ✭✭✭✭✭✭
06/23/20 Answer ✓
Options
Yes. I saw you found it. I should have noted that my two additional methods were just that: Additional tips for future reference. Sorry about that.
5 · Share on FacebookShare on Twitter
Answers
Brandi Cavender ✭✭
06/22/20 Answer ✓
Options
The primary column name will always be bolded. When you create a new sheet the column name will be primary column. The primary column can only be a text/number column.
5 · Share on FacebookShare on Twitter
Dennis Hoshield ✭
06/22/20 Answer ✓
Options
I don't see a bold column name. Is it initially a hidden column?
0 · Share on FacebookShare on Twitter
Dennis Hoshield ✭
06/22/20
Options
My bad ..... Found it. It was labeled 'Title'.
I copied the contents of my 'Name' column into it, and can now probably delete my original column.
Thanks!
Dennis
0 · Share on FacebookShare on Twitter
Paul Newcome ✭✭✭✭✭✭
06/23/20
Options
Another way would be to enter data down a few rows in any column then indent some of the rows.
The primary column is the only one that shows the indentation, and you should see the grey + and - boxes on the right side of the cells. (first screenshot)
A third option would be (as long as you don't have any left/right justification formatting applied to the columns) to enter a number in every column.
Numerical values are always right justified and text values left justified with the exception of the Primary Column. The Primary Column is always left justified by default even for numerical values.(second screenshot)
2 · Share on FacebookShare on Twitter
Dennis Hoshield ✭
06/23/20
Options
Hi Paul ...
I DID find it ... looking for the column heading in bold text. I went over all the fields multiple times. It was labeled 'Title', and I assumed it meant title for a Name (Mr, Ms, etc). We usually don't use designators like that, and I would have gotten a hint if I tried to delete it.
Putting numbers in each field would have worked, as well. Thanks for the tip!
I now have indenting and am playing with it. It's just a different process than what I would have used 30 years ago when I was developing databases! LOL I would have had the call/follow up logs (which is what the indent will be doing for me, I guess) in a separate related database, and used the client name or account number to relate the 2 databases. This should work pretty well, also.
Thanks for your help!
0 · Share on FacebookShare on Twitter
Paul Newcome ✭✭✭✭✭✭
06/23/20 Answer ✓
Options
Yes. I saw you found it. I should have noted that my two additional methods were just that: Additional tips for future reference. Sorry about that.
5 · Share on FacebookShare on Twitter
Dennis Hoshield ✭
06/23/20
Options
No problem ... always good to have options!
0 · Share on FacebookShare on Twitter
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 59.2K Get Help
- 86 Global Discussions
- 90 Industry Talk
- 398 Announcements
- 12 Community Corner Newsletter
- 71 Brandfolder
- 121 Just for fun
- 42 Community Job Board
- 22 Member Spotlight
- 1 SmartStories
- 250 Events
- 13 Webinars
- 7.3K Forum Archives
Watch video