-
Nest IFs coming back #Unparseable
I am trying to create a formula that returns “Green” if Project Day Variance is less than or equal to 0, “Yellow” if Project Variance is between 1-10, or “Red” if Project Day Variance is great or equal to 11. I tried to nest IFs, but I get Unparseable (see below): =IF([Project Day Variance]@row <= 0, "Green"),…
-
Once I select a country from drop down, I want the region to be auto populated in the next column.
Basically if I select a country/group of countries from drop down in one column, I want the region/s to be auto populated in the next column. Is there a way to achieve this?
-
Expaning Countif to include an additional criterion
I have successfully created a countif formula to count the number of times a word appears in a column. =COUNTIF([Medicaid Enrollment Status]4:[Medicaid Enrollment Status]158, "Enrolled") Now I need to expand it to include an additional criterion, "Enrolled-Provisional" I want to count all incidences in the column called…
-
Sumifs to count color symbols
Hello, I have a spreadsheet where I am tracking initiatives by team for each month and there is a color assigned to that initiative. For each month I assign these colors. I have a total of 12 columns. Green for on track, Yellow for at-risk, Red for breached, and Gray for not started. I really wished I could add one more…
-
Alerts not working
Hi All, I have a very simple smartsheet and if I add Yes in a drop down to a field (Output for Personnel File) then I want an alert sent. I have made settings unrestricted although the alert is to me and I am the owner. I have ensured that I save the data but nothing is triggered However, if instead of an ALERT someone…
-
Does using JOIN with the End Date field that is part of a dependency not work properly?
I am trying to MATCH on two fields, so I am using JOIN to make one field. The joined fields in my reference sheet are 1. a text field and 2. the END date field. When I MATCH to that JOINed field, I get #NO MATCH. But if I copy and paste that JOINed field into another field, I do get a match. Is that END date causing this…
-
Returning 3 results for approval results from multiple Approvers
Hi Everyone - First community post! I'm trying to work out a formula for the below scenario: I have an approval workflow set up for 10 approvers to one request. If everyone approves, I want to return a result for "All Approved" If everyone declines, I want to return a result for "All Declined" If no consensus is reached…
-
Count if
Hi I'm wondering if someone could assist me. I writing a count if for a column and it isn't counting the item if there is more than one answer in a row. Example would be =Countif([Case Type]:[Case Type], ="Birth Certificate". If you see below where Birth Certificate and SSI are in the same row, my formula is not counting…
-
Formula not updating
I have a very simple formula. =[Unit Price]@row * Units@row. It is suppose to take the unit price cell in the row and multiply it by the units cell in that same row. 9 times out of 10 it works fine, but every once in a while it wont update. This is causing us invoicing issues within out company as we have to go back and…
-
Count only child rows that have "Complete" in 3 columns
Hi I am trying to count the number of child rows that have "Complete" in 3 different columns. Here is my current formula: =COUNTIFS((CHILDREN)1, [HS Germ]:[HS Germ], "Complete", [HS Pave]:[HS Pave], "Complete", [Classroom]:[Classroom], "Complete") I keep getting "UNPARSEABLE". Any suggestions?