Sign in to join the conversation:
Hello,
I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list.
Thank you for your help,
Sohlbe
Hi Sohlbe,
Smartsheet lacks the functionality to sort rows automatically within sheets and filters do not allow you to sort either, so there is not really any way of doing this I'm afraid.
Even with Excel, you'd really need to write something in VBA to achieve this in the manner described.
I have a sheet with a list of non-distinct master ID numbers that are grouped into "Group 1" through "Group 6" based on a distinct secondary ID. I am trying to write a formula to grab the greatest priority value if there are differences within the same master ID. My formula is in the correct priority order. Here is what I…
I have a dropdown containing multiple values and I need to extract only the values like [CDB0040] [CDB0038]
I'm trying to combine multiple invoice #'s while referencing a daily/weekly record ID #'s. I tried using the Join/Collect function and could pull some of the invoices if there is only 1 daily/weekly record ID #, but can't pull the invoice # if there are multiple daily/weekly record ID's in that column. Is there a way to…
