-
Countif with Checkboxes
I need help doing a countif with checkboxes. I have a formula I need to countif in column Project if it has a value of Yes and column Parent Task is check. I also need it to countif column Project also has a value of partial. This formula worked until I tried to add the Parent Task column equaling 1. Anybody know what I am…
-
If(and(countif equation question
Attempting to make a status bubble roll up where the parent will turn green if there are any blank ("") cells except for when all child cells are blank. Below are some of my failed attempts: IF(AND(COUNTIF(CHILDREN(), "") > 0, COUNTIF(CHILDREN(), "") <> COUNT(CHILDREN())), "Green") results in blank cell only when all…
-
What would the formula be for.....
I need to sum or count the number of people in my sheet that are under 17 and over 65, based on who is checked. Can I do this using a cross sheet formula so all my totals are together? I have both DOB and age columns - can the formula be on the age column or do I need a value column to set age parameters?
-
Comparing 2 date fields and setting symbol
Hi. Just getting to grips with Smartsheet. I have pairs of date fields: Forecast Date and Actual Date. I would like to set a red status symbol if the Actual Date is past/older than the Forecast date. How can I do this? Alternatively I can set a check box if setting a symbol is not possible.
-
Formula
I am trying to write a formula that has multiple steps to it. I want it to see if the project is completed then to give me the Max date of completion.
-
IF Statement Help
I have a sales price database with one column for a retail price and another for a sale price. I'd like to make a 3rd column with a formula that populates the Save __% for our Marketing team. I made this formula which works with one small issue I'd like to resolve if possible. =IFERROR(("Save " + (ROUND(1 - ([Sale…
-
Sum of a column by cell color?
Not sure if this is possible or not. I was looking into conditional formatting, but didn't seem to find anything that would work. I simply want to get the sum of a column based on the color of the cell in the column. In other words, I only want to see the sum of red cells and exclude green cells. If this is not possible,…
-
If Formula
Good Day All: I am trying to create the following Formula however I am receiving an Incorrect Argument: If impact is High and Influence is High, then the Classification is Key Player My Formula: =IF(AND([Impact on Project]2 = "High", [Project Influence]2, "High", ="Key Player")) All help appreciated, Thanks!
-
Create table for Risks&Issue register
I have a risks&Issues register sheet and would like to create a table in a new sheet which categorizes based on Streams and risk/issue rating. How do I do it. Attached is the sample. I would like separate tables for risks & issues
-
Need a formula that works like a report -- date is within the last 30 days
I've been looking through the Community and can't find this...sorry if I've overlooked. I have a series of reports that determine if certain projects are within the last 30 days, such as added in the last 30 days, go live in the last 30 days, completed in the last 30 days, etc. This is very easy to do on a report and get a…
