-
COUNTIFS with Two NOT CONTAINS for the same Column
I need a formula to return the count of the number of rows where my Receipt # column is not blank, and where the Notes column does not contain insufficient funds and does not contain pre-authorized payment. I've gotten the formula to work for the first two criteria, but I can't get it to work when I try to add the criteria…
-
Simple COUNTIFS formula w/ # INCORRECT ARGUMENT SET
Hi, I am having trouble with a COUNTIF formula. I am using the below formula that keeps giving me the INCORRECT ARGUMENT SET error message. I used the same formula to count the blank cells on another sheet and that worked, but this is not counting the not blank cells. =COUNTIFS({Final Sent}, {Patient Status}, "Closed",…
-
Can you do a VLookup to a column that has multiple entries
I am executing a Vlookup to look for a single name in a cell that may have multiple names. I am getting a No Match error, even if I am specifying - not an exact match I have tried both True and False and with multiple values in a cell I cannot ensure an ascending order. =VLOOKUP(Approver@row, {Community Metrics}, 2, true)
-
Display an email address based on a name selected in a separate contact field
Good Morning, I have a sheet called "RFIs" used to track requests for information. I also have a contact list populated with my requestor names and email addresses. The RFI sheet has a field called requestor it is a single select drop down field pulled from the Contact list. The Requestor field displays the name of a…
-
How to duplicate the formula that sum across multiple sheets
We set up the sheet to report the daily sale volume of each project in the department. Each sheet is for one department. We create duplicate sheets for all departments in our company. Please see the screenshot. Now, we create a similar sheet to calculate the sum of the sale for each project for each day across all…
-
Automatic roll up of the same Field?
I have an internally corrupted data base. Our people have been inputting the wrong/random ID numbers for the same Model #. I exported some of our data from our database into a Smartsheet to see if I could sort them. Below is snip of a 20,000 row sheet that I want to organize by model number and have all the same Model #'s…
-
Unnecessary scroll bar on published view only report
Hi, I am working on a Dashboard for my team and when using a widget to display a report that is published/view only, there are way too many unneeded scroll bars. It is set up size-wise so that there should be no scroll bars, however there are two vertical and one horizontal. Is there any way to get rid of these? Thanks!
-
Condition
Hi there. I have a sheet with so many rows and columns, and I want to set a condition where if some specific fields are not blank, then that field will be highlighted. I managed to do that, but it seems like i can only set one column at a time. Is there a way to set that condition throughout the entire sheet, not just…
-
Multiple cell formula to calculate order QTY
Hi All, I'm trying to create a query that will divide the value of a column depending on the value selected in another. For context, we need to order a certain number of ink cartridges based on the number of badges we need to print. However, the number of ink cartridges also depends on the type of badge we are printing.…
-
Help converting a time formula in Excel to SmartSheet
I have an Excel spreadsheet with a column called Set times, an example value being - 6:30am > 6:45am (00:15 total) This value is unchangeable because it is exported like this from another program and is unchangeable. I have two more columns in Excel, called Time IN and Time Out The formula for Time In is -…