-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
How to reference 100's of items with corresponding triggers to designate an end date.
Hi - Our agency has a formal record retention policy that lists over 100 types of records that we store or have digitized in-house. Question to answer/example: If the documents for Site A fall under Record category 1, they should be destroyed on 1/1/11, which is 100 days following the trigger date. I was able to create the…
-
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…
