-
Percentage Complete Parent/Child
I have several child rows that are marked either Assigned or Completed. I need the parent row to tell me what the percentage complete is. So somehow counting the total number of total child rows and then counting the number of Assigned rows and the number of Completed rows then given me a percentage of Assigned rows. How…
-
Display RYG based on calc of two sheet summary fields and IF/OR statements
Hi, I'd like to display Red, Yellow, Green in a Sheet Summary field based on the calculation of two other fields, Past Due and Total Tasks. I'd like it to show Red if Past Due divided by Total Tasks is greater than 60%, Yellow if between 40% and 60%, and Green if less than 40% I'm new to Smartsheet so could be way off:…
-
Is there a way to conditionally format different colours to a calendar?
Is there a way to conditionally format different colours to a calendar based on the cells in the corresponding grid? i.e. Department?
-
I want to show Parent rows in a filtered Report
I have a column with an IF/AND formula to flag whether a "Milestone" is "At Risk" based on a series of conditions. I have a report that then filters on this Flag column to show such "Milestones". However, I would like this report to also pull in the Parent row of any "Milestone" rows that appear - which I call "Phase"…
-
How can I have cell C contents change if cell A changes?
Hey there all, I don't know exactly how to word my question - but I have 3 rows attached to contacts lists in the SmartSheet. Contact List A, B, and C. See below, for column C as individual's are added to this sheet, we will also add their Coach in column A. But coaches can change with tenure, so what I want to do is take…
-
index match within one column
Is it possible to match a value in one sheet to a value in another sheet in a specific column and return the number in the row directly above? Please help if anyone can
-
Formula help - reference data from 2nd sheet, with conditions
Hi, I’m looking for help with a formula for my sheet. Images of my sheets are below Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions. Populate Sheet 1 Holiday column with data from Sheet 2 Holiday column, only if: Sheet 1 Date matches Sheet 2 Date, AND Sheet 2…
-
How to compar two fields that have multiple options, any match = true
Example of my issue, Looking for match, from these two multi select fields. Field A, options are apple, orange, lemon, lime Field B, options are apple, orange, lemon, lime Field C. If match found = 1 User selects options apple, orange, lemon from Field A. User selects options apple, lemon from Field B. I want Field C to…
-
Is there a formula to indicate the change in status direction if updated in a given time?
I want to indicate with up/down arrows in a separate column, if the RYG status for a line item has changed direction in the last X days. e.g. if status went from Red to Yellow, Red to Green, Yellow to Green in the last 30 days - show an upward arrow; if status went from Green to Yellow, Yellow to Red, or Green to Red in…
-
CountIF
I used Excel and had used a formula like this =COUNTIF(B5:R5,"Y")/COUNTA(B5:R5) to calculate the number of Y's that were in the sheet. I then converted this answer to a percentage so that I could look at my data and see the percentage of times that something was occuring. I am trying to do the same thing in Smartsheets…