-
CONTAINS formula
Trying to get a formula to lookup a reference sheet to see if the ID contains the word BASE in it and return with a value SKUBASE if so and SKU if not. I feel like I'm close but just missing something. I had a formula where if I checked the box "add base" it would simply add the suffix BASE to the id however this is all…
-
IF Function not working for me
I'm referencing a Birth Date in a sheet and want to use the IF Function along with the Month Function to isolate the month of a person's birthday date. The DOB column is in DATE Format (i.e. 12/05/75). Some of the rows do not have any data populated in them, and I'm trying to return a blank (i.e. "") for those conditions.…
-
Index Match Function Help
Hi All I am using the following formula to pull over a contact from another sheet if the request id number columns are the same. It appears to work for some entries but others it is showing #NO MATCH. Both the columns containing a contact are set as contact list columns types. Can anyone help? =INDEX({Appendix B Approval…
-
Copy PARENT cell data to CHILD CELL without deleting DATAMESH field links.
Ok, I have a challenge with formulas and data being overwritten. I am trying to create a FILTER for my procurement teams to use. I ONLY want to show items where the PROCUREMENT COUNTRY is "CHINA". When I create that filter the CHILD rows do not show because the PROCUREMENT COUNTRY is "BLANK". So I need to copy the PARENT…
-
SUM formula
Hi. I'm trying to sum cells in a sheet with functions. It returns with 0 instead of the correct number. What is the workaround for this?
-
SUM if a condition is met
Hello Community, l browsed around and couldn't find a solution that would apply to my issue. I am trying to sum the total amount per district code. Important note is that a troubleshooter can work any of the districts so l need to leave the grouping per Troubleshooter but sum up the totals per District. So far l have used…
-
Ancestor Formula for RYG
Hello, I am trying to create a Status for the Overall Project using the Ancestor formula based the Parent-Child status. It is NOT based on %. I cannot seem to make it work. It works well for the Parent-Child but then when i try to go a level up it is Unparseable :( This is what I have at the Parent level…
-
Using Match Function with Multiple Contact Column
Hello, I need to lookup a value in a table when a specific contact matches. I tried using match/index, however the column containing the contacts in the lookup table allows multiple contacts which I am unable to determine how to use match with multiple contact listings. The use case is as follows: Send an email alert to…
-
Send alert to task's assignee when predecessor task's status changes to complete
Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notification to auto-send to a task's assignee when the task's predecessor's status changes to "Complete"?
-
Countifs formula help for multiple dropdown selections
I am attempting to count different dropdown selections that have historically been amended. For example, where dropdown options were "Multi"; "M/A" but is now "Multi-Account", I need to count all 3 potential selections for a single year. Where a single value has always existed, this is the formula I'm using:…