-
COUNTIF Cell Value is Negative
Hello! I don't yet see this question put out there, so here we go: I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exist in that column. (This is for a sheet summary). Currently my formula looks like this: =COUNTIF([Delta: Projected Hours vs.…
-
IF cell CONTAINS one/two/three different values, return corresponding values
Hello community, I am attempting to return single or multiple values depending on a multiple dropdown column. My dropdown column contains criteria "Consolidation", "Reduction", "Termination", "New" Currently the formula works for single values with the following formula =IF([Type of Project]@row = "Consolidation", "🝢",…
-
Sumifs or countifs and what is the formula
I have 3 columns of data: Column 1 is a location (for example 101, 102, 201, 202) Column 2 is a date (for example 12/1/2023, 12/2/2023) Column 3 is a duplicate transaction labeled as D or if not a duplicate it is blank Based on the location of 101, I want to see how many transactions occurred on 12/1/2023, and are not a…
-
Depreciation Cost Help
Wanted to use the template listed to create a new sheet and see if it would work that way, but it isn't available any longer.. Essentially, I'd like to be able to find the depreciation cost year over year of assets currently being tracked in a sheet. We display the cost price paid on purchase, and the date of purchase, but…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
Can someone help me come up with a function to calculate a date 1 month ahead?
For example, in column A I have the date 1/22/23. Now in column B I want it to automatically calculate 2/22/23. I know how to add 30 days to a date in a formula but since not all months have 30 days I want it to show the exact date in the next month.
-
Count Columns in data sheet to appear in calc sheet.
I need help writing a Smartsheet formula that examines the "status" and "County if known" columns in a data spreadsheet. I want it to count the number of each type of status for each county. The Smartsheet containing the data is named "Test of File a complaint" the sheet where the calculation will appear is named…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
COUNTIF Cell Value is Negative
Hello! I don't yet see this question put out there, so here we go: I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exist in that column. (This is for a sheet summary). Currently my formula looks like this: =COUNTIF([Delta: Projected Hours vs.…
-
Can someone help me come up with a function to calculate a date 1 month ahead?
For example, in column A I have the date 1/22/23. Now in column B I want it to automatically calculate 2/22/23. I know how to add 30 days to a date in a formula but since not all months have 30 days I want it to show the exact date in the next month.
