-
COUNTIF reference not working
I have a time entry on one sheet where times are entered in the HH:MM (24 hr) format and another column that pulls the hour of that day. [Time Received (FORM)] - time in HH:MM format [Received Hour of Day] - pulls the hour of the day with the following formula: =IFERROR(LEFT([Time Received (FORM)]@row, FIND(":", [Time…
-
Install Comparison Actual to Projected
Good Morning Community. I wanted to ask a question as it pertains to a comparison. We have been asked to show a chart that displays installed, not installed and projected installed. The premise is that in our project we have specific dates that are targeted for installation but with everything in project management that…
-
Date Range and status formula
Hello, I have a metric sheet where I am trying to build a formula that references a date range column and status column of another sheet, but I keep getting "unparseable" or "incorrect argument". I have tried the following formulas: =COUNTIFS({Event Date},>=(2024, August, 1),{Event Date}, <(2025, August, 1),{Event…
-
Formula to combine data from another sheet
I just had surgery and I am trying to keep track of my medicine inventory. So I created an inventory log of my medicine and I have it split into 4 columns as I want to keep track of each medicine so that when I am running low I can ask for a refill. So I have two sheets. Medication Count Management Medication Management I…
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
index and Match that Sums everything
i have right now =INDEX({Project Tracker - By Work Package Range 1}, MATCH([SYSTEM/CABLE]@row, {Project Tracker - By Work Package Range 2}, 0)) this works great but it only comes back with the First number it finds. i need it to Come back with a Sum or Total of all the Numbers it finds. Sheet i want the info on. working…
-
How can I get this formula to return a value when two criteria are met?
Initially, I used the formula below to return the Payment Term value from my Contract & Exhibit Tracker where the vendor #s match between my source sheet and output sheet. And it worked. =IF(ISBLANK([Vendor #]@row), "No Match Found", IFERROR(INDEX({Contract & Exhibit Tracker - Payment Terms}, MATCH([Vendor #]@row,…
-
Calculating % of completion based on start & End dates
I'm looking for a formula that calculates the % of completion based on start and end dates
-
Formula to determine next available date
Im trying to determine the next available date based on end date, Job status as active and the event type contains install. This formula returns a date =MAX(COLLECT({End Date}, {Job Status}, "Active")) Ive tried adding the contains install but it doesnt return a date =MAX(COLLECT({End Date}, {Job Status}, "Active", {Event…
-
Is it possible to generate a part number from row data?
Can this be done; we currently manually generate part numbers and I'm wondering if it can be done using a formula or another option in Smartsheet. example below. Part number would end up being, SDE-04111YI2E82Y from the inserted URL Any help would be great.
