-
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…
-
How to count total checked in report instead of just total number in report?
I am trying to use the report to summarize some data to ultimately put in a Dashboard. In the screenshot I am actually trying to count the total number of T4C completed which would be indicated by the check mark. Instead it is currently counting the total number in the report, checked or unchecked. I am using a report for…
-
Index Function Help
I am trying to index data by date and have applied the formula to the column. The problem I am running into is the last data entry is repeating to the end of the dates I have listed for the year even though those dates have not occurred and are not even listed on the sheet I am looking to. =INDEX({Census}, MATCH(Date@row,…
-
Is there a way to delete a cross sheet reference?
I had a working formula referencing another sheet. It was referencing a set of cells in a column. I changed it to look at the entire column and started getting an #Incorrect Argument Set message. I tried to change it back to the range of cells and I'm still getting the error message. I wanted to delete the cross sheet…
-
Formula help for date <90 days and text "includes"
So really stumped on this one, my formula is working with the exception of the text including "Test". I need to have a star (1) put into this cell IF: Column [Expiration Date] is <= 90 days from today AND another column (Client) includes the word "Test". My current formula (auto-generated) is not working, any help is much…