-
Parent row to give a percentage when Child rows below are populated
Hello All Can anyone help me with a formula for my parent row below. I need to work out what percentage of days in a week I have booked out for our staff on projects. Currently I do this manually. As the only formula I have found have been for Tick boxes or completed tasks. The jobs are selected from a drop down list and…
-
Change risk color per multiple variables
Hello. Need some help with a multi variable formula. I have a RISK column. The column type is Symbols (Red, Yellow, Green). I have an END date column. I have a STATUS column (Not Started, In Progress, Complete) I'd like create a formula that by default the RISK is Green (green circle). If it is 2 days past END date it goes…
-
Counting range of cells within row
I'm trying to count the amount of times a cell within a row has a specific word: =COUNTIF([Labelling)@row,[Training]@row), "Fail") If Fail shows in any cell I want the function to result a readout of 1. If two cells have Fail, then the result would be 2, etc. Instead of my expected result, I get #UNPARSEABLE in the cell.…
-
How do you summarize symbol statuses?
I have my team provide project status updates on their goals via a "Request an Update" automation; we use the bar symbol (empty, 1/4, half, 3/4, full). Upon an update being made, it will change the status accordingly in the respective row. I have objectives that the goals ladder up to, and I'm trying to figure out a way to…
-
Average of an If Formula
Hello! Can anyone provide some insight on why I am unable to get an average on a column of IF formulas? Here is the formula across the rows in the column: =IF(Status2 = "Not Started", "0%", IF(Status2 = "In Progress", "50%", IF(Status2 = "Completed", "100%"))) I am getting a #DIVIDE BY ZERO error when I use the AVG formula…
-
Count PM name + % completed based on 20%, 50% and 90%
I tried using the below formular but was not able to get the output. =COUNTIFS(PM:PM, "Cameron Kang", [% Complete]:[% Complete], "20%;50%;90%")
-
How to auto-check a checkbox based on a checkbox from a different sheet?
I tried using If(COUNTIFS..) formula but it's not working. How can the results from the checkbox be transfered to a new sheet using a formula? Thank you
-
COUNTIFS INVALID OPERATION
=COUNTIFS([FirstName]:[FirstName], [FirstName]@row, [LastName]:[LastName], [LastName]@row, [Retailer]:[Retailer], [Retailer]@row, Quarter:Quarter, Quarter@row) #INVALID OPERATION. OK, I feel really silly here... why isn't this working?
-
Formula Tweak
Hi - How to I adjust (add to) this formula so it sums Green and Gray for Clark Usher? =COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, "Clark Usher", [Primary Status]1:[Primary Status]10, "Green")
-
Formula for =text(A1, "000000-0" ?
I am looking for a similar Smartsheet formula that excel has that takes text from a column/cell; say 12345-7, and changes to "0012345-7" - forcing the cell to be in a specific format. Excel uses "=text(A1, "0000000-0")