-
CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti
I need a COUNTIFS formula (I think this is the best option based on research) that calculates all of my technical resources task status for all of the projects. An example is below. I have 4 current projects and 7 resources. Please see the screenshot for an idea of what I'm trying to accomplish on a Metrics sheet that…
-
Managing Multiple Audit Sheets
I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria and yields a single score on the top parent row showing plant, audit, date, and score. Since there are multiple plants,…
-
Update a cell in a column with data from a different columns
Hi, I'm trying to select a range for the completion status and also trying to refer to a different column and get the data updated in a different column. I'm sure I'm doing something wrong here. Please help me! =IF(COUNTIF([Completion Status]3:[Completion Status]38, 0) > 0.5, "Not Completed", "Pending Mgmt Approval",…
-
Tracking changes to a Column within last week
Hello, I'm trying to find a way to count the number of items which have been updated to a 'complete' status within the last week. I have 10 sheets and they all have a status column (not started, started, complete etc.). I've tried using the 'modified date' column to determine if the status was updated, although I'm aware…
-
Using IF formula to drive status
Mine is a little different than what I've found here. I have 4 columns: Closed Date and Completion Date, Status column that has 4 choices: open, closed, complete, overdue and a Due date column. If closed and completion are blank, the status should be open If Due date has passed, status should be overdue. If completion is…
-
Project scheduling - moving from Excel
We currently use Excel but want to move our Scheduling spreadsheet to Smartsheet. Here are some details: * We have 8 employees that can weld. * Some of the 8 can work on small parts, some can work on large parts, and some can work both. * Our Sales Orders may contain small parts, large parts or both. We list how much time…
-
stacked if formula based on DATE and Drop down
Good afternoon all I am fairly new to smartsheet but an intermediate user of Excel. For some reason, my multiple stacked IF OR formula for Dates is not working - i know it must be simple but ive been staring at it and really need some help Test Frequency is a drop down list: Daily/Weekly/Monthly/Quarterly/Yearly In a…
-
Date Function not working
Howdy Experts I am trying to get a month number from a date in a corresponding column. I use the function =MONTH([Incident Date]1) but i get back #DATE EXPECTED. the date column has the date format of Jan 11, 2019. I just need the month number in order to run a report based on incidents that occur in their corresponding…
-
SUMIFS, cross-sheet reference based on dates.
Sorry if this is a duplicate. I couldn't find an answer that fit my problem.. Formula: =SUMIFS({AccHours}, {ShipDate}, <=Date3, {completed}, <>"x") All references are from another sheet except Date3. Date3 is a formula as well, which is TODAY()+2. This works in Excel, but doesn't seem to work here. I don't get an error,…
-
Data derived from mulitple criteria
Hello Smartsheet Friends, I have a single text box that I'd like to do some data analysis on, and wondering if there is a way. My text box is similar to the below "Product, Engineering, IT, Supply Chain, etc......." I want to pull all of the instances of "Supply Chain" and do a sumif. Aka total number of submissions for…