-
Calculate number of days a task is later than forecast end date
Hi, Can somebody help? I need to add a column that calculates how many days late tasks less than 100% complete are compared to today see below example, basically need a formula that calculates the 'working days late' column. Thanks forecast end date % Complete working days late (based on todays date) 3/8/20 99% 2
-
Return a sum using using sumifs and dates
My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting.. This formula returns a value, but I've checked manually, and I've determined the value is incorrect. I've exported a filtered view of the sheet,…
-
Nested IF Statement Help Needed
Hi there, Here is what I am trying to achieve: If the % Complete column =100%, then return Gray to the status If a task is overdue (using the End Date column), return Red to the status If a task is due within 5 days, return Yellow to the status Is a task is due in 6 or more days, return Green to the status If there is no…
-
How can I update this formula to exclude a column?
=COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started")) - COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started"), {Post TSA}, 1). I need to add to the formula (I am not good at…
-
RYGG balls based off of the date
Hi there! I am working to automate the RYGG balls and its like I can get parts of the formula to work separately but not all together. I added a Past Due column to use to try to refer to that indicator to get the formula to be a little less complicated. The goal is: If Due Date is blank =then no balls or "" If the Due Date…
-
SUMIFS to Calculate Values for a Specific Year/Date Range
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date range. I have searched the community questions, and I haven't been successful in finding…
-
Managing different Holidays calendars
Hi, In my schedule, I would like to manage different holidays calendars associated to different department. In this example, I have 2 Departments to manage : "Dept1" and "Dept2" I have created a specific "Holidays" sheet to manage the different holidays for each departement with a date column called 'Dept1' to list all of…
-
Multi Select Dropdown Witih Criteria pulled from Another Smartsheet
Hello! I am attempting to create a Smartsheet form. When a user completes the form they need to identify every account that will be impacted by the project associated with that form. How can we include a multi-select filed in the form, with which all accounts to select from are included in a separate smartsheet list? is it…
-
Count children rows by status
Hi - I have a sheet with parent rows and children rows. Each child row is associated with a status (Not Started, In Progress, and Complete). For each parent row, I'd like to count the number of child rows that are in each status. I need to present this information in a dashboard . Ideally I would create a separate summary…
-
VLOOK to a diffrent sheet #NO MATCH
I'm getting the #NO MATCH error when cross referancing to a nother smartsheet file that has close to 20k rows, do you think this is causing the error. I looked up one of numbers and see it but still getting the #NO Match error. It is not finding any of my 500+ rows? Any thoughts here? First image is teh {Smartsheet BNI BU…