-
% allocation
I have read a few posts regarding the inability of the tool to automatically update duration based on changing % allocation of a resource i.e. Task A will be completed with 1 day duration by Resource X. I change Resource X to 50% allocation and the duration should automatically be updated to 2 days. The last post I read…
-
Cell Change Counting
Hello, Is there a formula that will count the number of times a cell changes? Thanks, Rozan
-
Monthly Management of Projects
Hello All, I am now responsible for reporting on the progress of multiple projects in our organisation and what is going on. I have created Sights for each that roll up into an overall position to save time and effort. However, I would like to create a task list for myself to make sure that i have covered all bases on…
-
Trying to add a Sheet Data widget to a sight
Hi, I'm trying to create a Project management Dashboard but for some reason, when I click on "add a widget", I don't see the option to add a Sheet Data. Does anyone know why and how I can do this? THanks! Carine
-
hide certain columns per user
Basically: I want to hide certain columns for specific users. In detail: I have 7 users shared to an affiliate sheet. This sheet contains the assets needed for marketing as well as rev share and money exchange. I want my graphic team to update the status of graphic assets but I don't want them to see the rev share columns.…
-
Status RYGG Automated Formula
Hello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s Date is less than “Planned End Date”, and “% Complete” is less than 100% * Red (Task has not Started on Schedule): Today’s…
-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
-
Editing Alerts & Notifications - how do I get rules to fire on existing entries
Hi All, Basically I want to know how I can re-fire alerts and notifications that failed due to errors and have been subsequently edited. Example described below We are testing a new smartsheet using alerts and notifications and a multi step approval process based on thresholds. We submitted multiple Smartsheet forms today…
-
Update Request Forms that Include Parent Rows
I am relatively new to using Smartsheet and have just introduced this tool to the business. In order to gain good buyin I am using the update requests to show how easy it is to keep sheets up to date. The one thing that is a little disappointing about this great feature is that there doesn't seem to be a way of including…
-
Predicting a bad situation
I have projects with 3 milestones, call them A, B, C C is dependent on B which is dependent on A. C is a critical completion date. If either A or B is late, C is automatically late and that is very bad. If A or B is late by X number of days, C automatically is now going to be late by that same number of days. I'm looking…