-
Help with Countifs
I am trying to figure out the formula for my metric sheet. I am wanting data to populate based on a date column and a column that allows for multiple selections (comes from form). Here is the sheet that my form dumps into. So, I am refencing the date column and the column on the right Where they can select 0-30ish things…
-
Need help hiding checkboxes
I have a handful of project intake sheets, that ControlCenter looks at to automatically generate project files if approved. We have 2 types of projects that are intermingled on the sheets, and use 2 automations in CC. I'm now running into an issue with some users checking both approval boxes, and CC generates 2 sets of…
-
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.
-
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…