-
Calculate percentage complete on a project based on time elapsed
I need help to finish a schedule for projects based on time elapsed. The current formula that I am trying to use has a Datedif formula but I don't think Smartsheet supports that. Any ideas or assistance would be helpful? =DATEDIF([Projected Start Date]@row, [Projected Finish Date]@row,[Actual Finish…
-
IF AND with Less and greater than is not working
I am trying to use this formula. IF(AND([Time Remaining]@row = "Closed", [Closed Date ageing]@row >= 90,[Closed Date ageing]@row <= 180), "90-180 Days", "More") where [Closed Date ageing]=203 but still it is giving output "More" Can you please tell me where I'm making mistakes? Thank You Suman
-
Estimated Capacity Calculation
Hi All, I am running an estimated capacity calculation on Smartsheet, the raw data (=attendance tracker) is also stored on Smartsheet & the pages are linked to each other via references. I am using for the calculation headcount and the average of the monthly target, the only problem is that from the available headcount not…
-
COUNTIFS for assigned to CONTAINING a name
I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0 =COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed") Anyone help!?
-
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"), [%…