-
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.
-
Merged: Allow a column formula to be from a fixed cell
This discussion has been merged.
-
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…
-
Parent/Children Formula
I am trying to have a formula look at a "Parent" row Status IF it is blank than to then look at the child row associated and if the Status is Red, Green or Blue, place status within Parent Status ONLY, if it is not any of the listed status leave blank. I have the below formula, but it keeps throwing a #circular ref error.…