-
Referencing a cell on another sheet based on information in its' parent
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 tracking sheet for each project. It looks up a unique project ID, parses that central tracking sheet for the latest row with…
-
Is the Today function actually being forced to update?
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 subsequent rows are added to this Smartsheet. Using automation, the "Delete_Task" row is copied into this sheet from another source…
-
Tracking % Changes Over Time
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 information is all linked & calculated from the scope-specific sheets. Column 1 shows "# of steps completed to date", column 2…
-
Nested SUMIF formulas across multiple sheets
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 multiple hourly rates. We will call this doc "Hourly Jobs Breakdown". (Rates will all be in $00.00 format, I just forgot to…
-
VLOOKUP/IF or INDEX/MATCH?
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 columns "resource name" (text), "onboard?" (check box) and "milestone paid?" (check box) If the resource name matches, AND…
-
Updating Date Column if Another Column has been Changed
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 every time the sheet is opened and saved. I only want the Date cell to change when a specific other cell is changed.…
-
Using a formula to Reference another sheet with two variables
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 Server" AND (RefSheet1Range2){Status}="Completed") This would return a count of the number of Windows Servers that have been…
-
Quality Control Record
Hi, I am trying to create a smartsheet to track the quality of a constructed panel. The constructed panel needs to be checked at certain points by different team members. The data needs to be stored to each individual panel. I have tried using forms to submit the data onto a sheet however if i want to add multiple columns…
-
How do I use conditional formatting to highlight upcoming dates that do not match?
For example, I am using cell linking to pull in two different large pieces of data from two separate sheets. What I'm trying to resolve is how to flag column 3 date if it does not match column 2 date. I want to highlight the dates that don't match so we can resolve as to "why", internally. Thank you for your help with this…
-
I want sync a field across multiple sheet, being able to edit it from any of those sheets
Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New. When we agree that the team will work on it - we add the Unique identifier to the "Prioritization" sheet and the…
