-
COUNTIFS Resolved (or not) within 2 days over the last 7 days
I have the following columns: Date (I refer to this as 'Date Opened' below) Resolved (checkbox) Resolved Date Formulas in the 'Sheet Summary' section I am trying to create these formulas to reflect on the last 7 days, will be used to make a dashboard chart widget: Resolved on time (2 Days) over the last 7 days Count the…
-
Finding Duplicate User IDs in one column
Hello Smartsheet community, I'm trying to identify duplicate User IDs in the same column and in the same sheet. The typical user ID has 6 numbers in it (example: 100054). We are working with around 10k user ids. We've tried this formula: =IF(COUNTIF([User - Employee ID]:[User - Employee ID], [User - Employee ID]@row) >…
-
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…