Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Ordering Search Results

Options

Bob C

Bob C ✭

07/08/16 edited 12/09/19 in Archived 2016 Posts

Is there a way to order search results from the Current Sheet by their line number within the sheet?

Tags:

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

07/08/16 edited 07/08/16
Options
Not directly.

I often create a RowID column with the formula

=RowID1 + 1

in row 2 and copied to the rest of the rows.
I have to update this manually when adding/deleting rows but works.
I also make the font big and bold so I can read them.

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Arrows in a text row with other text.
I have created a sheet to track roadway sign damages and repairs. I have text column where I add the message for each sign. I want to add an arrow in the text string. Currently it shows: "Greenbo Lake / State Resort Park / (left arrow) 15 Miles" The 'slash' / denotes a line break. I want the (left arrow) to be an actual…
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
Formula issue
I am using the following formula and getting an #UNPARSEABLE message. I have 3 field conditions that I want to check and set the box to "B" otherwise "S". I Task complete is a checkbox. =IF(AND([Status] = "Closed", [Change Type] = "BOM Cleanup", [Task Completed] = 1), B, S)