-
How to find average for two different items?
Hi all, I'm trying to find the average day to process two different types of material. 1. raw material, 2. non-testing material (Material Type Column). In the release timeframe column, I have counted the days between the created and release date. But what I'm trying to do is to get an average time to release raw material…
-
Task Management - Total Count for Section when Adding/Deleting Rows
Good morning! How do I track the total count for a section of rows without having to manually update the formula if a row is added or deleted from the section? For example, I have a section with this formula - =COUNTIF([Include in Total Task Count]2:[Include in Total Task Count]10, "Yes") If I add a row to the section, is…
-
Index & Match - Match from another sheet, provide data from another column in the same row
I have a sheet where I want to lookup/match a specific field from my active sheet [Computer Asset Tracker Lookup]@row to a 26-column-wide range {CBH HP Computer Asset & Software Tracker Range 7} in a separate source sheet. The exact/unique match would be found in column 1 in the specified range, and then I need it to…
-
Automation in one sheet to change cell in another sheet?
I have two sheets in our workspace, one is the master list of projects we are working on, the other is used to record the amount of time each person works on a project for a given date. Projects sheet Timesheet sheet Project ID Project ID Project Name Staff Name Status Date Priority Hours Worked etc. etc. A project gets a…
-
Formula if a cell is blank, run one formula, if not blank run another formula
Hello! I want to track the amount of days a person has been in each stage of their transition – specifically Pre-boarding and Onboarding. I wrote the below formula not thinking that once Pre-Boarding ended and Onboarding started that the formula would keep calculating as I used TODAY. What I need is a formula that says “If…
-
New here, general questions
Hi, Do you have to write all the functions yourself or are there tools to help with the process. I need to do a xlookup index and matching update to another sheet. I'm use to work with ablebits tools. While I'm here, it is possible to upload to a file to overwrite (update) data on a current sheet? Can I sync two sheets so…
-
Formula- need to Sum OR Average based on another cell
I need some help with a formula. I have: =IF([Goal Calculation]@row = "sum", SUM([Quarter 1]@row:[Quarter 4]@row,IF([Goal Calculation]@row = "average", avg([Quarter 1]@row:[Quarter 4]@row)))) The problem is it is only updating to reflect SUM. If I change it to AVERAGE, the cell goes blank. So I switched it and put AVERAGE…
-
Count The Number of Upcoming Deliveries Within a Certain Number Days
Hey there! I've tried everything. All I am trying to do is produce a formula that counts the number of deliveries we have in a certain number of days that is not in "lost or cancelled" status. This helps us keep our eye on the prize to ensure we are doing all of our tasks prior to the delivery date so the customer can have…
-
Convert to Column Formula
Is there a work around for "Convert to Column Formula" in the Primary Column that has an hierarchy? We love the hierarchy groupings and I do have a formula there that gives a sneak peak of the name and site assigned at first glance but it is cumbersome to go to the sheet to copy the formula down. I was hoping it could be…
-
Employee Fit Testing Tracking
I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, noting that some employees with have to complete fit testing on multiple masks each of…