-
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…
-
Formula to return non-blank value from multiple cells
I have a number of columns in a row and only one of them will be not blank at any one time. I'd like to program another cell that will "look" at these cells and return only the value of the cell among those columns that is not blank. Is this possible?
-
Formula Help - Not sure what I am missing here
I'm working with a formula that should indicate the stage of an employee's onboarding based on a table. The stages are labeled as "PHASE COMPLETE," "PHASE NOT STARTED," and "PHASE IN PROCESS." However, I'm encountering a few issues: When everything is marked as complete, it returns an "invalid formula" error. If no phases…
-
Calculating Dwell time
I am trying to get the dwell tome to show in my sheet by using the formula below, but it wont bring back a value for me in days only showing '0', I have applied the formula to the whole column 'Dwell time' what could I be doing wrong please ?