-
RYG Formula help!!!
I am trying to update RYG using Variance (baseline end - Finish). If Status is complete Gray If Variance = 0 Green If Variance =>-1 and <= -5 Yellow If Variance >-5 Red =If(Status@row = "Complete", "Gray", If(Variance@row =>"0", "Green", If(Variance@row =>"-1", if(Variance@row <="-5", "Yellow", If(Variance@row >"-5",…
-
Parsing \
Have a column called Manager Short Name. I want to parse out the ID after \, example EMEA\abcdf I have tried many variations of =RIGHT([Manager Short Name]@row, FIND("\", [Manager Short Name]@row) -1) I get #unparseable I have used this same formula in other columns but I have not had \ as the factor its been . or /. Some…
-
Help with an If / AND / OR Formula please
Hi all, I am looking for some help with an If / AND / OR Formula please. My issue is as follows: I am looking for a formulate to automatically populate a 'Status' column based on '% Complete' and 'Finish' column(date column). I would like the formula to display the following outcomes for each task's 'Status' 'Complete'…
-
IF Statement with ??? to move cell data
I have the below as my main sheet (plus additional columns that aren't relevant). Then I have a separate sheet for each Name. On the separate sheet I want to record the "Unique Identifier" if "Approval" = Approved. Originally I thought of combining an If statement with index match but don't have anything on the "Name"…
-
Workflow Questions
Hello: I have two questions that I hope someone can help me with. 1) If I have a bunch of workflow items (calls, emails, texts) laid out on a daily cadence until the person responds. Is there a way to automatically mark them as 100% as soon as they respond, and I enter a Start Date in the next section? 2) Is there a way to…
-
Countif Formula Help!
Hello I have a formula at the moment that is calculating the tenure based on different ranges. The below is example is for those with tenure between 1 and 5 years: =COUNTIF({GOAL C8 Participant Tracker Range 1}, ">1") - COUNTIF({GOAL C8 Participant Tracker Range 1}, ">5") However, I want to add another criteria to this…
-
Update column info every day
Hey, So I have a list of different ports that a ship is going every day. The list goes until 2025 so I want to create a formula that I can see in one column the port that the ship is located today. Any recommendations? Thanks
-
Dynamic View not showing the values of a formula column that is a Read-only in the data options.
When trying to add a new item on dynamic view after i have picked my question category it should return a specific question on the next line (with no changing option, read-only). It does not show my specific question, after i hit save for the new entry it does show. But the problem is that i need the submitter to see the…
-
Sheet to Dashboard Help *LONG post!*
Okay, I have played with this for over a month now so I am going to ask the question from square one and tell you what I've already done to see if anyone can help me figure out how to do this, because I am certain at this point I am making it harder than it needs to be 😂 I will redact some of these screenshots for privacy…
-
Need a formula to return a value by looking a table from another sheet.
I have Source sheet with a list of names. In Target sheet, I will be having a column with other set of names. Need to compare the names in Target sheet with Source sheet and return the value which has same name. However, if the name list in the Target sheet does not match the name list in the Source sheet then "NA" value…
