-
IF/AND cross-sheet formulas
Hi there, I'm getting error messages with my formulas and was hoping someone could help. I'm trying to create a formula with the logic below: IF [Lot Number]@row in my target sheet = Lot Number in the my inventory form AND [Status] in inventory is "Approved" THEN check a box in my target sheet. Whenever I try to reference…
-
Formula for weighting tasks on a scale of 1-5
I have a sheet that is a master list of all of my ongoing and upcoming projects. I have a multi-select column that has a list of tags for product type. I would like to have a column that looks at the product types and assigns a number to indicate complexity. For example: Product Type 1 = 1 (simple) Product Type 2 = 2…
-
Exclude weekends from date calculation
Hello, Is there a way to exclude weekends from a date calculation? I have an application with start and end dates and I want to calculate the number of days between the start and end date, not counting weekends. I have this formula working but it includes weekends so if someone takes a Friday and a Monday the calculation…
-
NETWORKDAYS Concern With Future and Past Dates
Working on creating schedule variance icons, I am running across an issue which might be solved with absolute values of NETWORKDAYS but wanted to understand how to better structure the formula correctly. In this example I have two helper check columns Delta Check 1 and Delta Check 2 provided below. The problem I'm having…
-
COUNTIFS And OR
The formula below works, but I have a situation where I want to count when two different attorneys are listed in the Attorney field. =COUNTIFS(Attorney:Attorney, ="Attorney1", [Contract Status]:[Contract Status], OR(@cell = "Customer Legal Review", @cell = "Pending PAC", @cell = "Pending SRTC", @cell = "Sent for…
-
Adding multiple columns if one column equals X
I have a multi column sheet. If column Alone= CN, I want to total four columns. =SUMIF([$ Regular]:[$ Regular], [$$ xyz 2021]:[$$ xyz 2021], [Per Item $ 2021]:[Per Item $ 2021], [null 2021]:[null 2021], [Revised $$]:[Revised $$ ], (Alone:Alone, CONTAINS("CN", @cell)) I've tried ever iteration and I cannot figure it out.…
-
If all = Competent then competent, if not, then inconsistent
Hi all, I need help with a formula. People choose their skill based on a certain topic: Competent Inconsistent Expert I need a formula that looks at all the children and determines that: If 1 inconsistent, no matter what else, show as inconsistent If all competent or expert, show as competent I am guessing it can be easily…
-
Formula to find todays production
Hello Smartsheet Experts! Im hoping someone can help out here... :) We are attempting to see if we can get a formula that will give us todays production based on the percent complete? i.e. the project is worth $100 and on day we complete 20% so the value would be $20. Day 2 we progressed to 50% so our value for the days…
-
At months on to a date
I am looking to add months onto a date based on what is shown in the column highlighted in the screen shot. It is simple in excel using "Edate" but I can not seem to get it working in Smartsheet Thanks in advance
-
Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame. For example: I only want smartsheet to look at the surveys completed…