Hello, I am trying to work backwards but I just don't get it. My event date is my constraint, I want some tasks to be completed x days prior to the event and Smartsheet to calculate the start date of …
Hi, I am looking to populate the status of parent row to symbol: Red, Green, Yellow Parent Row: Red Symbol = If ALL child rows are red symbols Yellow Symbol = If ONE of child row is yellow or green or…
Hello, I'm trying to link data from a master sheet to two other sheets. Here is what I tried so far, but it's not working. Created a form on the Master Sheet. Tried Cell linking the master sheet to tw…
Hi everybody, been melting my brain trying to get this one I have a bunch of project sheets set up to send their rows back to a central tracking sheet. I have a Master Status sheet that parses that tr…
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subseque…
I have a master sheet (linked to many other, scope-specific QC sheets) that calculates % completion per task. Each row is for a different task, and each task has their own amount of steps. This inform…
I am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have mult…
Hello, I'm not sure which combination of formulas I require (VLOOKUP, IF, INDEX, MATCH...) In sheet 1 I have the columns "resource name" (text) and "onboarding paid?" (check box) In sheet 2 I have the…
I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date e…
I'm trying to create a formula for a report that references another sheet but it needs to reference and check two columns. My crude formula below to illustrate: =COUNTIF ((RefSheet1Range1)="Windows Se…
