-
How to automatically copy selective columns to a different sheet once project status changes?
Hi, I'm trying to copy selective columns to a different sheet once the status of the row changes to "Released". The goal is to create a different tracker from that data. (only for released material). Attached you will see a few columns example. I have a bunch in that sheet. Please see attached.
-
I need help creating a formula that pulls information from two columns.
Hello All. I need help creating a formula from two columns on one sheet and pushed to the summary sheet/dashboard with the totals. The first column is a drop down menu for the order status (New, Processing, Billing, Completed, and Cancelled) and the second column contains a check or is unchecked. I am counting the drop…
-
I can't get the PARENT formula to work without a reference
I'd like to use the PARENT formula to retrieve the data from the parent row for a column called Task Name If I use =PARENT([Task Name]) I get #UNPARSEABLE If I use =PARENT([Task Name]3) in row 3 I get the parent data as expected for row 3, and if I drag the formula it auto-updates the reference. However, I then cannot turn…
-
Counting number of contacts in a cell, "Allow Multiple Contacts"
Hello. I'm trying to count the number of people (contacts) who appear in cells in a contact list column, where I allow multiple contacts. Using a COUNT function always returns "1", independent of how many contacts are in a given cell. I'm not looking to return how many times any specific person appears, only to count how…
-
Formula to calculate the number of minutes request for a specific date and review board
I have a sheet that is an agenda submission for teams, and then another with a list of dates that calculates how much time is left for a specific date and review board (Primary Column). I have three review boards on the same date, so I want this sheet to pull only the Meeting Duration (Duration) for topics going to one…
-
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],…