-
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…
-
How to update dates to a new future date
Hi I use smartsheet as payroll check system. I normally maintain a group name, pay date, direct credit date. For some groups we pay weekly and for some we pay fortnightly. How do i automate date column with future date once i complete the payroll on certain date. Example Group Name Payroll preparion Date Direct Credit Date…
-
Prevent deletion of rows if it contains locked cells?
We are trying Smartsheets for a project and are running into a major issue. The sheet contains checkboxes of things to do, along with dates, and who did the particular task. It is crucial that the 'Task' and 'Date' columns be protected. Unfortunately, we're finidng that if you are an editor, even though these two columns…
-
Training Plans - Central & Individual
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
-
Help with Bulky Formulas/Formatting?
Hi all, I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. There's a final "Totals" column that sums up your monthly invoices. Currently, I have a hidden column set up to test if PO…
-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
Copy Conditional Formatting Rules
Hi, I tend the same conditional formatiing rules across several Workspaces and sheets. Is there a way to copy the rules so I can use them on new sheets? Thanks.
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
