-
INDEX/MATCH not working for some values
We have been creating a pharmacy inventory system where we scan in items and fill out the relevant information for the items in a form for our incoming stock: Then we made a second sheet for items going out that only includes the barcode. I was then planning to populate the rest of the information using INDEX/MATCH from…
-
Forms - and the receipt
Hello, I have developed a form to request items to order. Outside of this form but in the sheet, I have another column set-up with a Vlookup code that pulls pertinent information from another set of data about the request based on a selection made in the form that I want to be included in the final receipt of submission. I…
-
Formula VLOOKUP or maybe an alternative solution
Hello, I am trying to develop a formula that will reference another sheet and bring back the content from a specific cell. Need to reference two columns for the match in the reference sheet. The match component will come from a column [PI or Account #] on the main sheet to be searched in column 1 on reference sheet and…
-
Having an Issue where I am doing a duplication check and what to email the duplicator email back
Hi, I need help figuring out a method to emailing a set of duplicate emails once. I have an intake for that records emails. If there are duplicate emails in the list of emails, I would want to email them back to tell them that they just submitted a duplicate email. However, The way i have set it up now, sends the same…
-
Text to populate when Box is Checked
I need to populate text in a cell when there is a box checked anywhere within a row. This is what I came up with, but it isn't working =IF([Weekend Travel:WeekendTravel]@row = 1, "Weekend Stay")
-
Concatenate Formula in SmartSheet
I am in the process of migrating workbooks from Excel to SmartSheet, but am having trouble with the Concatenate formula. I have a column of store numbers and am trying to automatically create the store manager email to be used across different sheets, but I cannot use the concatenate formula in SmartSheet the same way as…
-
Formula Help
I am seeking assistance with a specific formula. I am creating an employee snow deactivation request and tracker. Employees can schedule time off during winter operations. The issue is that we have two periods, Preseson and In-Season. The Preseason period to submit your vacation is 7/15/25 thru 8/15/25 and In-Season is…
-
Count If formula using cross sheet reference
I've inherited a massive sheet and leadership has asked that it not be modified. There are 5 "actions" per row. I'm trying to count if any of the 5 actions are classified as "high" significance. The goal is to chart the number of "high" actions by function. =COUNTIFS({DD Input sheet - system team function}, "franchise",…
-
How to COUNTIF with multiple criteria and cross-sheet references
I am trying to create a COUNTIFS formula to count the number of times a book title appears in a range from another sheet AND if a checkbox is checked (also from that other sheet). The cells with the book titles contain multiple titles so I've been using a CONTAINS formula to match for each book title. I can get both…
-
Leave cell blank
Can someone help me update both of these formulas to leave the cell blank if the total is 0? Thanks =SUMIFS({Award Total}, {Grantor}, Grantor@row , {FY Awarded}, [FY22]@row , {Status}, HAS(@cell , "Awarded"), {Funding Source}, HAS(@cell , "Federal")) =SUM([FY22 Total]@row , [FY23 Total]@row , [FY24 Total]@row , [FY25…