-
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…
-
#DIVIDE BY ZERO
Hi, I have a Smartsheet with calculated columns like - =SUM(Open@row / SUM(Open@row:[Past Due]@row)) The Smartsheet is being used to create Donut graphs on a Project Dashboard. In the example above; Open = 0 In Progress = 0 Closed = 0 Past Due = 0 rather tan getting 0%for Open, I get #DIVIDE BY ZERO How do I resolve this?…
-
How to find (max less one) from a list of entries
To assess whether a team is progressing, my user needs to show the most recent score AND the score just before that one. The difference between the two will show direction of development. Finding the score associated with max([date of score]@row) is reasonably straightforward. Any ideas about how to find the score for the…