-
Archiving rows with formulas that reference other sheets
I've build a pretty large Smartsheet for tracking data yearly contracts for each of my 60-70 clients on therapy caseload with formulas in each row that reference other sheets and pull numbers from daily log forms. I need a simple process for archiving a row when the year contract is complete. I want to save a snapshot ofโฆ
-
Nested if helper column to set project size
Hi all, I am trying to create a nested if statement to set the project size to Small, Medium, or Large based on the estimated number of hours that project will take. This is what I have: =IF([Est Effort (Total Hrs)]@row = "30-120 (2-3 weeks)", "Small", IF([Est Effort (Total Hrs)@row = "120-320 (1-3 months)", "Medium",โฆ
-
Index/Match
I am trying to Make one column of Required Certificates and then I have a column of tickets that are obtained. I would like to see a column that outlines the missing tickets that still need to be obtained I was thinking: =INDEX([Certificates Required]@row, MATCH([Certificates Obtained]@row, 0)) I just changed my columnsโฆ
-
Checking a checkbox if one checkbox is unchecked, another is checked and falls between 2 dates
How can I get the formula below to work? =IF(AND([checkbox1]@row, 0, [checkbox2]@row, 1, [date]@row, >=DATE(2022, 4, 1), [date]@row, <=DATE(2022, 6, 30)), 1, 0)
-
View Predecessors in Reports
Is it possible to view the Predecessors in a Report? When I create a Report from a Project Schedule, it does not show the Predecessors dependant on that task, it only shows the number of predecessors. I eventually created a duplicate column and put in a formula to copy the value of the Predecessor column and use that newโฆ
-
Fixed project end date with predecessors
I have a plan with durations and predecessors. I was given a hard end for the project to finish.ย Is there a way for smartsheet to calculate the start and end dates for the tasks leading up to the hard finish date?
-
Need help correct a complex formula
So, I am working with this formula, which works great, but I need to throw in a CONTAINS aspect into it...and what I am trying is not working. Current formula (that works): =AVERAGEIF([Project/Task/Issue/Risk Name]:[Project/Task/Issue/Risk Name], ="Stage 2", [Actual Duration]:[Actual Duration]) How would you add in theโฆ
-
sum of parent rows only, below parent and child rows
Itemized budget rows, which are the sum of child rows. All data entered in child rows and totaled in the parent row. At bottom of page, I want to total the parent rows only. Any way to do this? Screen grab attached.
-
How to link a row with children to another sheet
So I figured out how to link cells between sheets, but my source sheet has a structure 2-3 levels deep (rows with children). If I try to link the entire sheet it shows up at destination sheet but the structure is flattened.
-
COUNTIF HELP NEEDED
Good afternoon. after getting some rude comments, I am re-asking this questions. I have a Calculation sheet that I do all my calculations on as they are tied to a Dashboard. On this Calc Sheet, I want to count data in a column on my Summary Data Sheet. Goal: to count cells in the Summary Data Sheet, from the Contractโฆ