Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
% Complete not totalling correctly
I have a roll up task with several children (All are indented under the parent). All but one of the children are at 0% and one is at 100%. The Parent is showing 100% yet I have several tasks that either have not started or are at 0%. Not sure what I am doing wrong and did not see anything like this in the forum. Thanks Don
Alert based on Harvy ball or "last changed date" system column?
I have a harvy ball that shows the progress to completion on a task. Is there a way to send a conditional alert to someone on the task line when the harvy ball gets to a 1/4 or 1/2 full? or even when it changes value (other than any change) Also is there a way to get a tickle when a sheet is not complete and has not been…
Work Column
Hello, In MS Project there's a column called "Work". that if I write for example for an X task, 6 days in the work column, and assign 2 persons on this task >> the duration will be 3 days. How can I have it in your gantt? G.
Car Rental Calendar using Gant
Hello Everyone; My wife and I own a car rental company in beautiful St. John in the U.S. Virgin Islands. The previous owners have always used a paper calendar reservation system which essentially has all 70 cars on the right hand side of the board and three months of columns to the left. Is there a way to ceate a gant…
Notifications
Can I limit visable columns when sending shett out to others via notifications
Is there a way to copy a sheet's conditional formatting rules to use on another sheet?
I would like all of my sheets to have consistent formatting,
Changing attachment line
Is it possible to change the line an attachment is on, without deleting from the old line and manually adding to the desired line?
How do i get the parents to display the date range of the children?
Can the SumIF check against multiple values instead of one?
I need to sum up a column if the value of another column is equal to EITHER X or Y. I was able to write the formula to check against 1 value but I want it check against mutliple values. =SUMIF([Hours]1:[Hours]10, Org104:Org110, "X") I want it to become : =SUMIF([Hours]1:[Hours]10, Org104:Org110, "{X", "Y"}) Is this…
Tracking resources, their hours per task and their hourly rate
Using a standard project template, is there a way to track resources (licensed and non-licensed), their hours per task and their hourly rate. This way I can calculate their total hours worked x rate to get their cost.
