-
Why is my Index Collect formula not working?
My source sheet contains information associated with clients, including site locations, managers, addresses, email, and phone numbers. My destination sheet includes rows with that site information. In some cases, a client has multiple sites. To capture all of the sites (rows) associated with a particular client, I added a…
-
Index collect = incorrect argument set
Hi there, I am using index collect and cannot understand why I am getting an error message "incorrect argument set" =INDEX(COLLECT({Rack CMDB}, {Asset Tag}, [Asset tag]@row), 1) Cross sheet references are connected to the same sheet. Column format is Text/Number Many thanks in advance Sam
-
Create formula for monthly count of extensions
Currently tracking our active project extensions. If we get an extension in a particular month I want to be able to capture how many extensions we get within each month.
-
SUMIFS Delivery Date >= Inventory Date
I'm attempting to write a SUMIFS formula where one of the criterion is to compare one date to another. It is returning 0 when it should return 1830. =SUMIFS({PURCHASING QTY EA}, {SHIP TO PLANT}, "HUBER HEIGHTS", {CONDUIT PURCHASING JDE CODE}, "RPVC0412200", {CONDUIT DELIVERY DATE}, >={CONDUIT INVENTORY DATE}, {CONDUIT…
-
Formula not working
The formula I am using =COUNTIFS([Award Amt. Fall]:[Award Amt. Fall], >= [T&F Amt. Fall]@row) Data for it: ID First Name Last Name Balance Due Payment Made 123 Mickey Mouse $1,641.20 $1,642.00 456 Minnie Mouse $1,000.00 $1,000.00 789 Daffy Duck $789.00 $789.00 012 Daisy Duck $1,840.00 $1,922.00 345 Spongebob Squarepants…
-
cell reffrence changing when rows added
Hello all, i have a strange situation here. i have a sheet where we track all the POs that we go out and pick up from different vendors. in this sheet i have added some sheet summary fields, whhc count the number of total POs, POs picked up and PO s not picked up. i have made a dashboard to show these 3 things i mentioned…
-
Calculating duration with start/end day and time columns?
Hi, I'm looking for a way to calculate duration (preferably in hours) with start and end day/time columns (as pictured below). Currently entering duration manually and it's not ideal. The sheet in particular is for system downtime metric tracking and so knowing the date and time are obviously necessary. Date columns are…
-
IF AND In Between Formula
I'm attempting to mark whether a sale is valid based on the following criteria: Clinic must have had an AHHI-1 or AHNN-1 tracking code and Invoiced Date on the sale must be between the Start and End Date of the event. I've tried this multiple different ways but keep getting errors. Here is what I have: =IF(AND([Clinic…
-
Adding OR to Formula with IF AND
Hello Community, I am trying to add an OR option to this formula which currently works for provisioning without it. Basically I want to add Customer Country is not blank OR Project Type = Demo / Customer Evaluation. Formula should allow provisioning if Project Manager at row is not blank, Project Keyword is not blank,…
-
Formula for converting a word into a Date, so I can create a Calendar.
Hello All! Happy Smartsheet Day! I am in need of some assistance. I created a work log of firm assets that need to be maintained in perpetuity. I want to create a calendar view. In order to do so, I need to establish a start and end date. My end date will be the completion date. However, I need to create a start date based…
