-
Deleting Sheets that I can't see?
I recently became a Smartsheet admin for my company, though someone else is still the official plan administrator (when it comes to billing, etc.). People have been asking me to delete sheets for them, sheets that I cannot see because I don't own them nor am I shared to them. Is there a way to see all sheets in our…
-
How to get notifications when a new entry is added via a web form
I have a web form which users use to create a new line item that requires approval once added. An automatic notification must go out to the person that needs to approve. Thereafter a notification must go out to another user to inform them of the approval. How do I set up the notifications when a new line item is added via…
-
Daily Production Planning Process
Hi All, I am new to Smartsheet. I need some assistance on exploring how it is possible to do what I need to do using Smartsheet. Idea: I want to implement a agile methodology like SCRUM and use smartsheet to manage the planning. On daily basis, people executing the work needs to select what they complete in next 24 hours…
-
OR formula help
I tried to modify the OR formula and combine it with a function involving RYG symbols: =IF(OR(IF(TODAY() - [Order Due Date]2 > 0, "Red"), IF(ISBLANK([Order Date]2, "Red")), IF(TODAY() - [Order Due Date]2 > -4, "Yellow", "Green"))) There are basically 3 columns: Order Date, Order Due Date, and status (RYG). I am trying to…
-
Conditional Formatting: "Today is in-between Start Date and End Date"?
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached image - bright green is a "today" task, and the woodland green is default). How can I extend my conditional formatting to…
-
Resource Loading across projects
Hi, I have a situation wherein a developer is working across 3 projects, with his loading being: 1. Project1 - 50% 2. Project2 - 25% 3. Project3 - 25% When i plan his task for Project1, i need to ensure that he is only 50% and accordingly the duration for the task needs to be calculated. Is there any method where i can…
-
Sights & Gantt Chart
In my report, the Row description is showing on the gantt chart as I have set-up. However, when I look at the Sight Gantt chart it is gone. Also, my project starts in March and it keeps going back to January 01 for the display. This results in a lot of blank data that is useless.
-
Estimated vs Actual Time
How does everyone accurately document their Estimated Time vs Actual Time Spent on tasks for a project? Currently, in our planning process we assign a Start Date and an End Date for each task (with allocation %, duration, and predecessors for each task) once the person assigned to the task acknowledges and begins working,…
-
If then statement for Risk Management Matrix
Hi Folks - I'd like to feedback to write a formula that evaluates the following: =IF(Cell A1 "Acceptable" then??? Acceptable Tolerable Undesirable Intolerable "Then"... the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2,…
-
Trouble importing from MS Project
I get a master schedule in a XML file and the basic info all imports fine. There is another data field which won't import for some reason. It is a text field with essentially "assigned to" info. Any suggestions? thanks Bill
