-
Percentage Formulas and adding to SIGHTS
Hi, I am trying to use a formula based off of Counts or Sum to get a percentage of work done. Then I need to add that percentage into my SIGHTS Dashboard. I am having trouble finding an operator or formula to help me do this. Does anyone know how to best solve this issue? Thanks!
-
Counting Checkboxes of all Parent rows in a sheet
We have a sheet that has a multiple level hierarchy. One of the columns is a checkbox and I used the formula ="" + COUNTIF(CHILDREN(), 1) to count the number of checkboxes below each parent row. This created the number of checked box in the parent row. Is there then a way to count all the numbers in the parent rows (to get…
-
How to calculate the Actual Duration only when the Actual Start and Actual Finish have values?
Hi, I'm working on a Smartsheet of which two of the columns are "Actual Start" and "Actual Finish". I have a third column called "Actual Duration (days)". Both the "Actual Start" and "Actual Finish" columns are date type columns and "Actual Duration (days)" is a Text/Number type column. What I want to have happen is as…
-
SUM formula pulling 0 no matter what. Issue with using multiple formulas?
I'm attempting to have all resources check off each of the meetings they attend on a weekly basis and then pull in number of hours based off those responses. I've created a checkbox column for a meeting and then a number/text cell the right right. I wrote a formula saying, "if checked, populate with a 1.5, else keep null".…
-
Symbols not changing based on the value in another cell.
I entered: =IF(%3 > "0%", "Red", IF(%3 > "50%", "Yellow", IF(%3 > "85%", "Green"))) and all the cells are red. Not sure why the formula is wrong! . The icon is in the column "Indicator" and the value is in the column "%". Any help much appreciated
-
If Status "Complete" how can I set it to automatically update the color on the RYGG balls?
We would like to do conditional formatting or a function so that when the Status column is marked 'complete', it will automatically update the RYGG Ball color in the column next to it. Does anyone know how to do this?
-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Adding Text Value if checkbox is checked
I have two columns - One is a checkbox, the other is a text format. I'd like to write a formula that essentially says, "If checkbox is checked (true) then populate the word "Checked" in the text cell. Else if checkbox is unchecked (false) leave text cell empty". Are there any formulas out there that can do this? Thanks, -PJ
-
Find the value of the next month based on today.
How do I add 1 month to today? I don't want to add 30 days or anything, I just want to get to the next month and I have to be able to cross years. so if today is 2/1/2015 I want to find March is next; if today is 12/31/2015 I want to find Jan is next. Do I need a lookup or is there a date function that would get me this?
-
Counting Formula
What formula do I use to count how many times a name shows up in a column? For example: I have a column titled "Last Name" I need to keep a running count of how many times "Smith" shows up in this column.
