-
Why is December's NETWORKDAYS formula not calculating correctly?
Hi - I have this formula that works perfectly for the year, but when I get to December it is calculating an odd negative number. Can anyone help me understand why and what I need to do to correct it?
-
Creating a simple sequence formula for the column
Is there a simple method to create a sequence column in a helper sheet based on a specific number to start the sequence? To give an example, I want to sequence start with the number 25 and increase each row by 1 (ie. 25, 26, 27, etc.), not by any specific project or identifier, simply starting with 25. I thought selecting…
-
I'm wondering if its possible to do a formula that has X task averaging A hours.
Is there a formula that would be able to pull from a Smartsheet that it smart enough to be able to pull from multiple columns. Ex below. Say I wanted to pull the average amount of time (duration) for the "eat" task in year "2023", how would I go about this?
-
Assistance with an AND formula
I'm trying to use COUNTIFS - I have a column with multiple items and only want Client Success to be counted; the item also has to be In Progress; the below schema is not working: =COUNTIFS({Small}, HAS(@cell "Client Success" ), AND({Status2} = "In Progress")) Any help is appreciated.
-
Link from a cell-reference and make the answer a column formula
When we set up a sheet we did not add an 'industry' column. I can link to a metadata sheet to get that information and link it to a single cell on my sheet . . . however, I need to have that value appear on every line of a column (so that reports across with the info across industries can be sliced differently). I created…
-
Making a Gantt View with only working days (Mon to Fri, exclude public holiday)
Is there a way to remove weekend and public holidays from Gantt chart? I'm planning a project with long durations per milestone, I would like to see only working days in the columns; alternately, can I have the duration formula only calculate # of working days?
-
IF(ISDATE) not working?
I have "Column B" that pulls in a date from another sheet. And I have "Column A" that changes to Complete when that date populates into Column B. In addition, I have a criteria for which it should say "Eligible", "Not Yet Eligible", or "Missed". This formula has been working just fine for a while. I have been updating a…
-
WEEKNUMBER formula
Hello, I am trying to count the number of weeks between two dates. I have applied this formula =WEEKNUMBER([SD End]@row - WEEKNUMBER([SD Start]@row)) It doesn't seem to be calculating correctly. For example, returning "51" for a SD End date 2/3/23 - SD Start 11/14/22. That answer should be more like 11, right? What am I…
-
Formula Help
If I want to compare column 2 of Sheet D to column 2 in Sheet F, and return the value from column 1 in Sheet F to column 1 in Sheet D if 2D and 2F are equal, and not return anything if they are not equal, how would I put that in a formula? I think it's a vlookup but my formula didn't work.
-
Challenges with Summary Data Formulas/Dashboard Sometimes working
I have a first sheet that was filled out by people using a smartsheet form to populate a sheet for a certification program. A second program is only open to the people who were already certified in the first program, so they fill out a Smartsheet form with minimal fields, include a unique ID number, and the rest of their…