-
Dependency between multiple RYGG cells
Hi, Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e: Status Task AVG(ST1-4) ST1 R ST2 G ST3 G ST4 Y That way we could avoid manually updating task's status manually and also connect it between sheets. Thanks
-
Header column
Hi All, I am having the hardest time trying to figure out how to keep the top column of my sheet as a header column. Is there anyway to accomplish this in Smart sheets. I have created the form and a web form for users to add data but I want the data entries to post on the sheet under the header. I'm hoping someone can let…
-
Parent Rows as Milestones???
Is it possible to make a parent row a milestone as well?
-
Is it possible to apply conditional formatting to reports?
My current understanding of reports is that each row replicates the formatting from whatever sheet it pulls from. Is it possible to create conditional formatting rules within the report itself?
-
Column Dependencies/Conditional Formatting
Is there a way to have one column populate data based on information put in a second column? For example, I have 2 columns "% Complete" and "Task Status" I would like that if the % Complete is at o% the Task Status would auto-populate to say "Not Started". And if the % Complete is 100% the Task Status would automatically…
-
Reference a row by Task Name instead of by the row Number.
Here is my challenge. I would like to create a formula in a template based on a row's Task Name (Task Name is a column), not the actual Row Number. The Row Number for this Task Name may change from proejct to project so I cannot reference the Row Number. The formula is pretty simple. I have a Completion Date column and a…
-
Recurring Reminders
Is there any way to set recurring monthly reminders for each row for content which doesn't get updated? I am doing up a rental collection sheet, and need to set reminder for the person in charge on a monthly basis. Thank you.
-
Conditional Formatting a section
I have a balanced scoresheet. I'd like to have the header "Business Development" Status circle turn from red to yellow to green as the tasks below it are completed. For each task, I set the measurement as "completed" and it turns the Status cell green. Once 1/3 of the status cells are green, I'd like to change the header…
-
Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
-
Week Numbers
How do I display a week number in a field, that references of a date field.
