-
Looking to create a formula to count number of tasks
On the "Corporate Legal" row the formula in the "0 of 8" is the following: =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) I want to create a Parent Count for all tasks. There are other sections with the same setup. I want the parent section (the cell with a blue border) to count all number of tasks. So if I have "0…
-
How do I use @row in an IF formula when I am referencing many columns for 1 response?
I created a plan with 8 goals, each goal has their own objectives (range from 3-11 objectives each goal, and each objective has their own strategies (range from 3-12 strategies each objective). I want to reference any one of the 42 columns I created for the form logic so drop downs would reflect in the objective or…
-
How to have a formula reference a blank report?
(FYI I do not have summary sheet access) I have a sheet that has a list of open Job opportunities. Of course sometimes that sheet is blank because there are no openings. I created a second sheet for metrics that I could use to put a counter-widget in my dashboard. That is, in my dashboard there would be a metric widget…
-
How to change my status column when Completed column is not blank
Hi everyone - I am new to smartsheet and am trying to figure out a formula for the following scenario: When Completed Date is not blank, make status Complete, otherwise I want to leave whatever value is there (the value will either be In Progress or On Hold). Help greatly appreciated.
-
RGB Formula
I am wanting my formula to turn yellow if the end date is between 3 and days away. How would I make that work? IF(AND(Status@row = "In Progress", [End Date]@row > TODAY(-10), [End Date]@row < =TODAY(3))
-
Count IFS
I am trying to build a formula that will count the number first based one the COE name, then to give a number on each disposition status. I thought it would be something like: =COUNTIF({Policy Project Status Report Range 3}, "Global Rewards"),({Policy Project Status Report Range 1}, "Keep/Enterprise") OR…
-
Gantt Chart bars - different colors to distinguish
Hi all, Is there a way to change the color on a gantt chart view while utilizing it on a dashboard? I tried to change them from the report but I can't seem to find the option. Maybe I'm thinking that I've used it under the calendar functionality and getting confused. Can someone confirm?
-
Start auto-numbering from a chosen row
Good morning everybody ; As show in the picture below , I have a project schedule which starts from the row number 3 and I have a coulumn which contains auto-numbers ( Code livrable ) . But I want auto-numbering starting from the row number 3 whil row number 1 and number 2 remains empty . Is that possible ? Thanks in…
-
Adding formulas together / Invalid Data Type
While I can get the formulas to work on their own I can never figure out how to pull them together in one string. This time, I think it might be close but it's returning an Invalid Data Type which makes no sense as I know that the column that the formula is in is RYGG which is what I'm asking it to return. My use case is:…
-
IF Function Condition - UNPARSEABLE
Hello, I have the following formula that does not seem to be working. =IF([Result]19<0,100%,IF((AND([Result]19>=100%,[Result]19<103%)),100%,IF((AND([Result]19>=103%,[Result]19<106%)),75%,IF((AND([Result]19>=106%,[Result]19<109%)),50%,IF((AND([Result]19>=109%,[Result]19<112%)),25%,IF([Result]19>=112%,0%,0)))))) For every 3%…