-
Extract top risks from risk log for highlight reporting
Hi there I'm running a risk and issues log and need to pull out my top 5 risks and issues into a monthly highlight report. These are based on the original risk score and the score post mitigation(s). Within my highlight report I have a number of cell links which pull through parts of the project plan but because the risks…
-
Auto-fill formulas for children rows
I click on the parent row that is below the children and insert a new row. This comes up as a child row for the above parent but the formulas that those children have do not autofill to the new row. Can this be changed?
-
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A)?
-
Average Children Rows with RYG
Hi all. I'm attempting to calculate an average for RYG balls in the parent row. I have gotten to the point of calculating all of my colors, but I'm not sure how to get the average. Here is my calculation thus far: =AVG(COUNTIF(CHILDREN(), "Green") + COUNTIF(CHILDREN(), "Yellow") * 2 + COUNTIF(CHILDREN(), "Red") * 3) This…
-
Formula Separator
I'm attempting to create Red Yellow Green balls based on 2 formulas in one row. I have one formula for early, late, on time, and another for whether the phase has been completed. Basically I want to show green if the row is early or on time and/or if it is completed/cancelled, but red if it is late and/or stalled or not…
-
Formulas in Smartsheet
Im trying to get a formula to work in smartsheet. Can anyone help me out? =IF([Travel Type]1, "craftworker"), ".3", ".4") I want it to apply $0.30 to the cell if the travel type selected is craftworker.
-
Adding the sum of a range of cells using the IF function
Hi! I wonder if someone can help me. I have a range of cells using the IF function. I'd like to calculate that range using the SUM function in another cell, but it just comes back with the total as "0". Is there a special formula that I need to use to complete this action? Thank you
-
Formula with star symbol
HI, I was trying to use a formula with symbol. Here is the formula I wrote. The formula is working but I would like it to be the symbol Starred/Not Starred and not the words. My column property is symbol. =IF(Status1 = "Done", "Starred", "Not Starred") What am I doing wrong? thanks Marie
-
Formulas
Thanks for the help!
-
Text added in summary/calculation
In the video by Robin Sherwood demonstrating card view he shows his template with Summary tabs visible in the swimlanes. How does he manage to present the (50 secs in) summary with "Units: 1750" I think this might be more of a string just added to the front/back of the formula in his grid view for line 2 quantity (20…
