How to know the order of tasks in card view for use in table view

Joachim Mund

Hi all,

i need to do some calculation in table view depending on the order of the tasks in card view.

Which formula or function returns the order number of the task in card view?

Thank you, Joachim

Paul Newcome

That would be the row number after sorting.

Joachim Mund

Thank you @Paul Newcome

in my smartsheet the order of the tasks will not change in the table view if I changed the order in the card view.

Is this working with your sheets?

How, with which formula do you get the rownumber in the table?

Best wishes, Joachim

Paul Newcome

You would have to sort your sheet to match the card view. Then the row number will reflect the appropriate order.

To output the row number into the sheet so that it is usable, you would insert an auto-number column (called "Auto") and then in a text/number column you would use this column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Joachim Mund

Thank you @Paul Newcome , I will check this