-
baseline - actual dates
This post is in regards to this post below. I would like to get in touch with Jeremy michels to see if he will share the sheets he references with me.Any help will be appreciatedThanks so muchLouise Jeremy Michels601 ptsApril 5, 2015 8:30 pm I do the added columns now. We use it for both schedule and budget reasons. If you…
-
Creating a Summary View Sheet
I have a sheet which has information on Projects and Activities my team are working on across the whole of my region. If has columns such as Activity Title, Person, Region, Partner, Status This shee it great but I would like to create a linked sheet which gives me total counts for each for each Person I would like to know…
-
Formulas and Sheet Saving
All of the sheets in my solution have a date column for "Today". =TODAY() I use formulas in several other columns to determine if the checkbox column for Current Qtr should be checked. (same for Previous Qtr and Next Qtr) I use the checkboxes in report filters. Problem: Because my formulas are updating sheets daily, I have…
-
How do I use an OR function with a simple IF function?
I’m currently using this simple IF function (If Team Column equals “Undergraduate Robing”, check the box (formula below) but I need the box checked if the team column equals “Undergraduate Robing" or “Faculty Robing” or “Marshals”. Is this possible? Current Formula: =IF(Team1 = "Undergraduate Robing", 1, 0) Any assistance…
-
Change Management Solution
Does anyone use Smartsheet for Change Management scheduling? We are in the process of creating a change management committee and are currently housing our Change requests in Lotus Notes Database.... Which is less than desirable. Trying to see how we could use Smartsheet to accomplish this... Anyone currently doing this or…
-
moving rows upon completion of task
We want to move completed tasks within a given hierarchy to the bottom of the list allowing active tasks to "move up" Ideas?
-
Reoccurring Event
Does anyone know how or is there a work around for entering a reoccurring event one time but have a reminder sent to you every two weeks vs enetering the event multiple times?
-
Tracking Assigned Tasks
Dears, How to view a specific person tasks on smartsheet, i assign multiple tasks for multiple users so what is the best way to keep informed or to check the update of a specific person tasks. Thanks.
-
Automate archiving of completed tasks
I've copied a sheet of "Current Tasks" so that I can use the copy to archive my "Completed Tasks," otherwise they just fill up my task sheet. I notice that there's a feature for linking cells, but I'm trying to figure out if it's possible to have the rows marked as "Completed" automatically copied to the "Completed Tasks"…
-
Status Order Tracking (similar to the Dominoes Pizza Tracker)
Was wondering if its possible to create an online sheet for my clients to be able to get Status updates? Ideally I would want them to go to an online sheet and put in their Invoice number and it will tell where their job is at (With Designer, Proof Sent, At the printer, Completed etc.) Does anyone know if this is possible?…