-
NESTED IF FORMULA WITH PARENT/CHILD ROWS
Hi everyone, I am struggling with a formula to populate a parent row, as either "On Track" or "Off Track". This is dependent on how the child row compares to the "Weekly Goal". The formula I am trying to use is shown below but, Im doing something wrong. (screen shot of sheet also attached) =(IF(CHILDREN([January (Week…
-
=SUM - Military Time conditional calculation Formula
Need help with calculation of military time: I have two columns that I am using to track Admission time and Discharged time to determine and average length of stay. I am using military time for each column and storing the difference in a third column for each row =SUM(([Discharge Time From ER]2 - [Admit Time]2) / 100) Exp…
-
How do I use a wildcard or "contains" in my if formula?
For example, the cell reads "Smith, Johnny" and I want to write a formulat that returns a result if the cell contains "John". Normally I would use =if(cell,"*John*","YES","NO") with the wildcard * before and after John. But this does not seem to work in SmartSheet. Do I have the syntax incorrect? Thank you!
-
How can I display a date range based on week/month numbers?
Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals. At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc.…
-
Counting # of items completed late
Hi! I have two columns. One if the Due Date and the other is the Completed Date. I would like to set-up an equation where it counts the number of times an item was completed late (after the due date). Is this possible? If yes, what is the equation?
-
Trying to Clear a "Ball in Court" cell when item is complete
Help! We are trying to set up a formula to clear the "Ball In Court" when a line is complete. I know that you cannot format a formula in a contact cell, but there has to be a way! It's appearing as though work is still needing done and it is not plausible to remember to clear the cell each time something is complete. Any…
-
Automating R/Y/G/G Formula for some colors
Hello - Is it possible to create a formula that only looks for some of the colors in the R/Y/G/G drop down column. My drop down order in the Stage column is Not Started, In Progress, Completed. In my Status column I have Red, Yellow, Green, Gray. I am looking to create a formula that enters a 'Gray' icon when 'Completed'…
-
How to start counting the number of days up from a [Start Date] column, but ending it when the job i
Are you able to provide a formula that will for for the following: to start counting the number of work days up from a [Start Date] column, but ending it when the job is completed (whether is be an action or another date is reached)? Much thanks
-
Need Formula to count if cell values are Greater than 0.5
I have tried several different formulas to determine how many cells have a value greater than 0.5. The cells are qtr 1, qtr2, qtr3, qtr4, qtr5, qtr6, qtr7, and qtr8. The cells are not next to each other so it can not be a range. Any suggesstions? Forrest
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
