-
Index & Match Formula to provide row number if found in column
=IF(INDEX(ColumnA:ColumnA,MATCH(ColumnB@row, ColumnB:ColumnB,0), INDEX(Auto:Auto, MATCH(Auto@row,Auto:Auto, 0), ""))) Auto = System column to pull row number ColumnA =Text ColumnB =Text ColumnC= Formula location & Row Number Output So, what I’m trying to achieve is to have a formula to Lookup ColumnA text and match ColumnB…
-
Checkbook "Cleared" Balance
Hi, new here, so thank you for the opportunity to ask. I've got a simple checkbook set up, with all the typical entries: date, amount, type transaction, etc. I have a "reconciled" column, "CLR," that I'll type in "R" when it clears the bank. What I've been beating my head over for several hours is a formula that updates my…
-
Only Unique Contacts Formula
I want to create a column formula that pulls all the contents of multiple contact cells @row and only print the contacts that are unique. I don't want to print the same contact in there twice if here happens to be duplicates. Additionally, this needs to be a "contacts only" field so we can reference this for alert…
-
#DATE EXPECTED Error
I am trying to create an email reminder automation on one of our project schedules. We want the alert to go out 10 days before the line is set to be due (Finish Date Column). I created a date column to generate the reminder date (for the automation to use) by subtracting 10d from the finish date column. Some lines in this…
-
Formula to add leading zero to months 1-9 of the year only.
I need to add leading zeros to month numbers Jan-Sept only as sorting by month number does not work due to Months Oct-Dec starting with number 1. If I sort by month number, it comes up like this. 1 (Jan), 10 (Oct), 11 (Nov), 12 (Dec), 2 (Feb), 3(March) ... Does anyone have a formula for this?
-
Pull out some data from report into a metric sheet
Hello, I have created a report that shows the manager's name with the count of missing ratings. I would like to pull out this information and put it into a metric sheet that would have the manager name in one column and against the name a column with the number of missing ratings. I am very new to Smartsheet and despite…
-
Sheet loading issues - taking too much time to load the sheet
Hi, I have a order intake sheet where I refer the stock quantity from Item master sheet and grant amount from Grant master sheet. I'm doing most of the calculations(like quantity check and cost check) in the order intake sheet. in the particular sheet I have nearly 16 formula columns and multiple sheet referencing due to…
-
Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible.
I have a formula that works with one Criteria range however it is not working. The Formula that I am using is. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. Paid" + SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract…
-
I have a single cell I want to auto-add the sum
I have a cell that is for quantity of material used. Say I put in 3000. Tomorrow I want to put 2000, instead of manually adding it together to get 5000, how can I make that cell auto-add to get 5000 and not have to add it manually together.
-
Using Index, Collect and Contains in a cross sheet formula
I am working on a formula to look up a budget balance from a previous year's sheet and carry it forward based on two criteria, the {2023lineitemtype} and the {2023ExpenseDescription}. I am not sure where the formula is breaking. I could also be fundamentally misunderstanding how to use the contains function. I read some…
