-
Sumifs - NetSales per product, where the NetSales is in another sheet with product in MultiDropdown
Hello, I have a Product Sheet and one Transaction Sheet. I want to calculate the total NetSales in my product sheet (one row per product) by a SUMIF(s) into my transaction sheet knowing that, in there, the product is contained in a multi-dropdown. I tried the following: =SUMIFS({Master 20-21 Net Sales Y5}, {Master 20-21…
-
Adding only numbers in a column that contain certain text in another column
I need to add only the numbers in the SUBTOTAL VACANT USEABLE AREA column where the SUITE NAME column has the text "VACANT". Some of the suite names have text in addition to "VACANT" . These numbers need to be included in the sum as well, but I've not been able to make this happen- the formula I'm using will only include…
-
Should I use IF or IF(AND....or Something Else?
Good afternoon everyone. I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or…
-
IF function and returning a blank cell
Hi! I've tried several different versions of this function and haven't had any luck so far getting it to work. I want the function to return Yes, No, or stay blank as a way to indicate whether tasks were completed on time. Yes means the task was completed on time, No means the task was late, and blank means the task hasn't…
-
TODAY Function with COUNTIFS
Hi I have a formula just now which is : =COUNTIFS({Business Case}, $Measure5, {Business Unit}, [Brand X]$3, {PROJECT STATUS}, OR(@cell = "Shipped", @cell = "In Progress")) This is count the number on 'on time' and 'late business case's where business unit is brand X where the project status is either 'shipped' or 'in…
-
formula to calculate the week prior to a specific date (refer
Example: Look back 7 days from 5/3/2020. =DATE(2020,05,03)(-7) I’ve tried a few things and can’t get it to work. Any ideas? =COUNTIFS({Layoff - MASTER Range 2}, >=TODAY(-30), {Layoff - MASTER Range 1}, "Layoff") It could be that my column headers are dates and I don't have a date category/row to pull from. Any ideas?
-
Resource allocation %
if people are working on multiple projects, is there a way to get their available % on the sheet in a column? Something like "Overall resource availability". For ex. If Person X is working 50% on project A on date 5/18/2020, I f I am working on project B and add Person X to this project on a line item with date 5/18/2020,…
-
What if/then formula can I use for status color?
Hello, I need an if/then formula to automatically change the Status symbol to green if the date in the Batch Received column is within 7 days. And automatically change the Status symbol to red if the date is past 7 days. See example below: Thanks in advance!
-
Adding Sentences to Nested IF Formula, based on Impact
Smartsheet Community: I having Issues Adding Verbiage to my Formula: =IF(Impact@row = "Highest", "P1", IF(Impact@row = "High", "P2", IF(Impact@row = "Low", "P3", IF(Impact@row = "Lowest", "P4")))) P1: The issue impedes QA and/or further development until resolved. The code cannot provide the core functionality at all…
-
Usage of IF formula between sheets
Hi, I am using the IF formula to obtain a result in my sheet if the code is the same i have in another sheet. Example: Smartsheet1, If in cell A1 I have code "123", i need to verify if the same code appears in Smartsheet 2 and if yes i want that in Cell A2 of Smartsheet1 is reported the info that i can read in cell A2 of…
