-
Stuck on Multi-criteria countif function
Hello, I am trying to find active pilots at risk by using countif to find the following in a range: Planning Pilot Execution Pilot Summary Approval to Launch That have a status of red or yellow Is there anyone great at these who can help? This is what I have so far: =COUNTIFS(Sheet - Pilot and Readiness Pipeline - Pilot1,…
-
Need help calculating estimated completion date for production while excluding weekends
Hello Smartsheet Community! I have a project I am working on for work, and I am struggling with a formula to calculate the expected date of completion for our production orders based on a few criteria. A few things are missing that are confidential, but I have attached a picture of a practice spreadsheet: Please note: a…
-
How to get the formulas to correctly count the completed tasks?
The current formula counts every task for the total. =COUNTIF(DESCENDANTS([Planning Done]@row), 1) + " of " + COUNT(CHILDREN([Task/Topic]@row)) + " Done" I have been trying to get it to only count when all subtask from its proper row have been completed. There are 4 tasks and over 60 subtasks. When the subtasks are…
-
COUNTIFS Error
Here is my formula: =COUNTIFS({All Qs}, "Yes", {Hospital Match}, [HFMC Score]$15, {Month}, [Primary Column]@row) I am getting an #unparseable error. Each component works using COUNTIF. Do you see something I don't see. Thank you, Linda
-
Formula to show duration days in Months, Weeks, and Days
I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…
-
Due Date w/Multiple Conditions
Hi Community! I'm looking for some help. I've been tasked with creating a "notice tracker". The team would like the [Due Date]@row to be some what of a dynamic date. Here is a snip of the sheet and the columns I'll be using. The sheet is fed via a form. The form has "Response Due Date" but is not required. It will only be…
-
Selecting two values from a column, for a calculation
I'm a long time lurker here - thanks for all of the other questions and answers that I've learned so much from. After trying multiple approaches, I've been unable to solve this challenge,, so looking for wise input. I have the following type of table in Smartsheet (not posting that exact screenshot for confidentiality).…
-
Formula to Change Symbols in Column Depending on Review Status
Hi all! I'm working on adding a formula to a column to populate status symbols in another column. I've attached an image of the sheet for clarity - I would like to display the symbols in the 'Director Approval Status' column, with the original dropdown selections listed in the 'Director Approval' column. Here is the…
-
Combining multiple IF(OR statements
I'm trying to combine these three functional IF(OR statements into a single working formula: =IF(OR(Webinar@row = "Session 1|Afternoon", Webinar@row = "Session 1|Evening"), "08/24/2023") =IF(OR(Webinar@row = "Session 2|Afternoon", Webinar@row = "Session 2|Evening"), "08/29/2023") =IF(OR(Webinar@row = "Session 3|Afternoon",…
-
Sheet Summary with 2 conditions including date range
Hello, I'm attempting to write a summary sheet formula that sums a number based on two conditions: 1 for entries <1/1/2021 and another column with a drop down choice of categories for only one category. Any luck writing a formula for a sum of two conditions? Should I be using SUMIF? How do I format both the conditions in…
