-
Zero Formula
Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much.
-
Allow Successors() to show only immediate successors
I like having a "successors" column to complement the "predecessors" column - I use this to trace forward to find tasks that are affected if I make a change. However, the successors() function returns not only immediate successors, but every task that is a child of those successors. While this may be technically a true…
-
confusing formula results.
I'm working in a smartsheet that combines data from other smartsheets using vlookup formulae. I've written a column formula to add the values in two of these vlookup columns and in some of the cells I get the expected result, and in some I get a #NO MATCH error. I can't figure out what is wrong here. I've reviewed the data…
-
Index Match for Multiple Options
I want to set a formula that will index match the value(s) of a cell with a reference list of group name and associated contact information. Is this even possible? I have Sheet 1: list where each row has an entry that states in one cell, multiple group names I have Sheet 2: list of contacts by group name I want to have…
-
Moving children rows under a different parent row
Is there a way to set up a formula that will move project status "completed" from under one parent row to another parent row named "Completed project" once the project status has been selected as completed?
-
Formula for "Due date = 3 business days before Deploy date?"
Hi, I would like to build a formula with the following logic: "Due Date = 3 BUSINESS DAYS prior to Deploy Date." Building a "3 DAYS prior formula is simple enough, but I'm wondering if anyone has solved for logic that can only offer a day that's Monday thru Friday. I appreciate any advice! -Adam
-
Why does my Index/Collect Formula stop working after 8 rows?
Hello, my formula stops working after it gets through 8 rows. I have a picture below where I'm just testing out 30 rows but I need this to work for about 4000 rows, however I can't figure out why it gives me an error after awhile. This is my formula. =INDEX(COLLECT($ItemCategory$1:$ItemCategory$30, $[Date Order]$1:$[Date…
-
COUNTIF in an IF formula
I am trying to see when a segment is fully completed. Our segments can be broken out into subsegments, and they can have up to 5 subsegments, indicated by the segment number followed by a "—1", "—2", and so on. So far for this formula I've gotten it to count how many subsegments there are, but can't get the final push of…
-
Creating a bar chart showing task owner name and the count of tasks (25 possible task owners)
Hi, I am creating bar chart showing the names of task owners and the count of tasks assigned to them. I achieved this by listing the task owner names in my metrics sheet and getting the count by using the countif formula. But now I am told there is 25 task owners (instead of 5). So, I updated the metrics sheet with all the…
-
Forumla to checkbox if Parent Row
Hi All, I have a grid which will be used as a timeline function for market planning. I want to only see the parent rows on the timeline so I have tried to set up a formula to checkbox if parent row and filter the timeline that way. I've tried =IF(COUNT(PARENT(Task@row)) > 0, 1) that formula only checks chlid rows. I've…