-
Adding prices in a column if there are multiple statuses identified
Hi Everyone, I have no training in formulas and am only self taught. I cannot seem to figure out how to create a code for this situation, thank you in advance for your help! I would like the formula to add up the dollar values of one column when there are certain statuses selected in a second column, and also is identified…
-
Formula to get data to perform calculation starting at row 4000 downwards
Hi I am a bit of a novice with smart sheet formulas but hoping soemone can help i am using the formula below =COUNTIF(Status:Status, "Enquiry") This totals the number of enquiries we recieve which works fine but i would now like to create a formula which starts at specific row number - example row 4000 which is the first…
-
COUNTIFs referencing another sheet and tied to value in current sheet
Hi all, I've got a sheet with nothing but a list of dates for all of 2021. I want to add columns to this sheet wherein I count tasks in another sheet by the date and by the assignee. So in essence, the countifs would filter: -All instances of tasks whose DATE value in another sheet correspond with current sheet's DATE in…
-
Is it possible to reference the column name (Heading) in a formula?
I'm creating an invoicing schedule and so my primary column is a list of tasks and then I have columns for past, current and future months: Dec-20, Jan-21, Feb-21, Mar-21, Apr-21 etc. In the cells I enter a monetary value which is the amount we either have invoiced or plan to invoice. I want to have a column (Invoiced to…
-
Running total on a ledger
Hello, I have a general ledger that I'm trying to calculate a running total on. I'm trying to get a column formula in my balance column to continue from the Total Starting Balance in my Sheet summary all the way down the list by the following formula =[Balance]@row + [Debit (+)]@row - [Credit (-)]@row Is there a way to do…
-
cross-sheet reference, colored balls & workflow
I have 2 sheets that are communicating successfully. Sheet A has a column called "Application Status" that displays a red, yellow, or status green ball depending on a formula that references Sheet B: =IF(INDEX({Sheet B-RoutingProgress}, MATCH([Project #]@row, {Project#}, 0)) = "Yellow", "Yellow", IF(INDEX({Sheet…
-
Add to Existing Inventory
Good morning gurus! Here is our question of the week! I have an existing inventory of materials built into Smartsheet. Works beautifully so no problems there. What I would like to do is update the inventory by adding either a new line item or entering the information via form. For example: If I have 3kg of material XYZ in…
-
Nested IF-AND-OR within the same cell...
Hi All, I am trying to automate a cell based on the status selected in 5 different cells (all within the same sheet) For Eg., First 5 columns has the following Statuses. Complete Incomplete In Progress Sick Dropout Cancelled Scheduled Conditions are Main status is 'Complete' when all 5 columns are 'Complete' Main Status is…
-
RYG - Status no dates
I am attempting to add a column with the following formula: =IF([Priority]@row = “Green”, “Resolved”, IF(OR([Priority]@row = “Yellow”, “Pending”, IF(OR([Priority]@row = “Red”, “At Risk”) However, I received #UNPARSEABLE I am trying to obtain an automated response in the "incident status" column --> resolved, pending, or at…
-
Replacing contents of one cell with that of another in the same row
Hello! Is there a way, via a formula, to replace the contents of one cell with the contents of another cell in the same row, only if the second cell is not blank? I have a credit column (CC) and a partial credit column (PCC). If there's an entry in PCC, I want that value to replace the value in CC. Thanks!