-
Parent/grand-parent rows in reports
Hello! I have tried to follow steps in other posts, but my brain cannot figure it out :) Could anyone help me identify the helper formulas for pulling parent cells into a report? I need to pull in to a report the Goals and Problem Statements for any Projects that are identified as "Must Have". So I am trying to figure out…
-
How do I exclude a cell with checkbox from formula for a specific row?
I'm trying to use the COUNTIF statement to total a range in a row with checkboxes that are selected and provide the percentage of what was checked. That part worked (highlighted in screenshot): =COUNTIF([Thumbnail Image Rec'd]6:[Migration Complete]6, 1) / COUNT([Thumbnail Image Rec'd]6:[Migration Complete]6) The issue is I…
-
Add Duration to date/time
For a software release plan, I need to show the duration of a task but unable to translate my Excel formula to Smartsheet. Any thoughts? These are the fields I am using -
-
How to Round up date from delta for dates
I have a spreadsheet where I've gotten the Delta (time between end date of task 1 and beginning of task 2). it comes out as an integer instead of a whole number to reflect days. How can I use the ROUND function to reflect whole integers? An alternative: is there a setting within the Smartsheet that would allow for whole…
-
VLOOKUP Formula
Hi Smartsheet community! This may seem like a simple question but I cannot figure out this formula for the life of me. I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2. On sheet #2 it will be a list…
-
progress percentage cell not accepting formulas
Hi, I have a column to display the percentage of completion for each row, I would like to use something like the below formula in this cell, to automatically update this value, however, Smartsheet is not interpreting this as a formula, instead, is putting a ' sign before the = sign '=IF((Status@row = "Done"), [%…
-
Count status of tasks between 2 dates
Hey there! I'm trying to find a way to reference data from one sheet into another, with a formula that will count some metrics to display on my dashboard. I've managed to do it for counting task status for the whole project but am struggling to figure out the formula to narrow down specific tasks between dates. Previous…
-
Sheet Summary equation
I am trying to create an equation in a Sheet Summary field that counts all items that have not passed approval. This would involve counting all items in the Status field that are Not Started, In Progress, Failed, or On Hold. I have tried multiple variations of the CountIf and CountIfs statements, but everything is…
-
OFFSET Function
Hi, I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equivalent would be in Smartsheet. What I am trying to get at is this:…
-
Trying to Use Join and Collect in a function, Says Calculating, but blank result
I am having an issue getting this formula to work for me. This is based off a previous question asked and answered but I can not get it to work for me. Sheet "1.Master" where I want the consolidated information to go contains [Site No] column (unique identifier/primary column) and a column called "Zoning" among 50 some…