-
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?
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
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.
-
Allow a column formula to be from a fixed cell
We regularly need to repeat one value (like 'industry') to appear on each row of our sheets so that when we pull data together we can slice and dice more easily. These are often hidden columns so they don't annoy our clients. The challenge is that we would like to take the singular reference of 'industry' from our project…
-
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?
