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.
For progress column, I want to use the symbol column with bar option (Empty, Quarter, Half, Three Quarter, Full) and it should be driven by task % Complete. if % Complete Value is 0% then progress should be Empty, if complete value is between 0 - 35% then progress should be Quarter, if value is between 36-65% then progress…
I have a contact sheet and a main sheet. There are instances when I have 2-3 individuals that need to be notified based on the information on the main sheet. I created this formula to pull multiple emails from the contact list: =JOIN(COLLECT({Department Chairs}, {CourseName}, CONTAINS([APA Courses]@row , @cell )),…
I am designing a budget sheet and want to Sum a series of cells if they meet 2 conditions. 1st I want it to check an expense category, ie. groceries. I then want it to check that it falls within a specific date range. Below is an example of the formula i have built and it works: =SUMIFS({Expense Collector Range 4},…
