-
Help setting up a formula
Hello there, I'm trying to set up a formula that shows when a vendor is on holiday. We have a sheet shared with our vendors where they add their time-off, and another one where we send them work. What I want is to create a formula that pulls that data from the holiday tracker and shows if the vendor will be available to…
-
INDEX Function to return an entire Column
Hi. Looking for help using the index function in Smartsheet. In Excel I would use an Array index, notating my row_num = 0, in order to identify the column of the range that I want to return, but Smartsheet gives me a #INVALID COLUMN VALUE error. Any help much appreciated.
-
NETWORKDAYS Formula using TODAY() not returning expected results
I'm using a Formula to calculate the pays past due from today. The current formula I'm using is =NETWORKDAYS([Due Date],TODAY()), but the results aren't coming out as I would have anticipated. 9/29/2021 returns 2 days past due 9/30/2021 returns 1 day past due 10/1/2021 returns -2 days past due So, I created a formula that…
-
Linked sheets & inserting columns
Hi all I am trying to build a compiled set of project "master reporting" that pulls data in from up to 100 individual project sheets. The issue I have is that if I want an additional column to be added into both levels, I need to add to each individual project, then relink each individual project in the "master reporting"…
-
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…