-
Variance on task list
I have a sheet that is a running list of tasks that gets added to weekly. I am looking to figure out how to show how early, or late, a task is completed in relation to the due date. If the task is on time, I want to show 0. I have been trying to use this formula =NETWORKDAYS([Due Date]@row, [Actual Finish]@row) - 1 This…
-
Formula to pull the non-blank value from multiple columns
Not sure if this is possible but I'm trying to pull a non-blank value from one of multiple columns and paste it in a separate column. Essentially, there are 5 columns that are Department (Deburr, Lathe, Mill), Deburr Machine, Lathe Machine, Mill Machine, and machine (think of this column as the master column, or…
-
Overwriting column formulas
Hi folks, I've got a lovely column formula doing what I wanted it to be able to do. But, it seems that individual cells in the column are now uneditable. That was not my plan! Is there anything I can do to make the column formula apply in the first instance but then allow the cell to be editable in the second instance?…
-
Indenting on smartsheet causing calculation error- help?
Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my case specifically, =((8 * 5 * 7) - SUM(CHILDREN())) ) If a work order has multiple…
-
Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],…
-
30 Day look back
Hello, I am using the formula below to count all instances of rows that contain "ADCVD" in my "2022 Archive RFI Reason" with my "2022 Archive Created Date Range". My problem is that my Jan 21 data is located in in my "2021 Archive Created Date Range" sheet. How can I modify this formula to look back 30 days in both…
-
Need to Tally and List Unique Values From a Drop-Down
Hello, I have a sheet in which I am tracking distributor complaints. I need to make a few different graphs. One of which is supposed to be a line/tally graph of how many complaints have been made by each distributor. We have a list of almost 40 different distributors which we have in a drop-down select form, for the ease…
-
Count nr. of checkboxes based on another value
I have a sheet with actions. It has a status column (in progress and not started). Further in the sheet I have checkboxes per department. I'm trying to build a report, that shows the number of actions that have status in progress for the specific department. I can do the count of the checkboxes. but need to have the…
-
combining them in the same column
Hi, Can we show the date and time by combining them in the same column? thanks
-
Is there such a thing as COINTAINSIF?
Which function do I use to count the number of times certain letters eg PRJ and TRN appear in a range if in another column the project is open (not closed).