-
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:…
-
Turn Cell Formula into Column Formula
Hello everyone! I am at the beginning of making some operations sheets for my job and will need to rely on column formulas I have successfully input a formula in a cell and it works! When I drag the formula down, it works. However, when I try to convert it to a column formula I get the error saying that the syntax is not…
-
Copying Date to Text Cell
Hi everyone, Is there any way for a formula or automation workflow to automatically copy/insert a date into a text cell? I'm trying to create a formula where if the STATUS column is "DATE" it will then Copy the date the item was created into a text Column. Is this possible? Thanks!
-
Referencing a flag column in a Function
Hi everyone, I'm currently in the process of adding functions to my task list. I have two columns that I am trying to edit the functions of. One, (Needs Following Up) has a "priority" symbol to mark if the parent row has a child that is a follow up item. The other (Follow Up Item) marks if a row contains "follow up" in…