-
Countif & Contains
From what I can tell this formula should work, but it's returning a 1 when it should be returning a 2 =countif([Bakery - Emp Health, hygiene, supervision, knowled]@row,contains("C -",@cell) Help?
-
Returning value based on date in another column
Looking for a solution / formula type on the following: I want the Actual Phase Number column to give a number between 1 and 8. The number it will give is calculated by first looking at the Actual DOC column. The date in row 1 showing 12/13/22 will look at Scheduled DOC and find the most recent date before. In this case,…
-
Can Smartsheet Count Dates?
I have tasks in each month and want to count those tasks within each month in my metrics section. Here's my formula to calculate February tasks: =COUNTIFS([End Date]:[End Date], ">=02/1/19", [End Date]:[End Date], "<=02/28/19") In Excel this works, in Smartsheet I get a 0, but have tasks within those dates. Help!?!
-
Create column with unique values from another column
I am working on creating a sheet to be used for reporting. I have pulled in the contact list of names using the cell linking feature however, there are multiple rows with the same person. I would like to create a column listing just unique people. I started by creating a duplicate checkbox column using the formula:…
-
How to show last passed child on parent row?
I have been trying different ways to show last passed "gate" of a project. The project can have from none to few child rows. There is a column with passed gates as tick marks. Now I want to show the last passed gate text side by the parent row. I haven't figured out how to do this automatically. Any help is welcome!
-
Multiple Criteria and Date Range Formula
Hi, I am trying to create a formula that will reference another sheet, look at two criteria within the same column and a date range between two columns. The following works to get the two criteria from a column but I cant seem to be able to add the date range to it. =COUNTIFS({Sheet - Status}, OR(CONTAINS("Complete",…
-
Index Collect Based on Another Cell
I have a drill down sheet in which I need to collect the plan values from the master. Master Drill The Drill sheet contains SRC ID, Month & Year this can pinpoint a single value in the Master sheet. If I create a range containing only the Jan column it works: =INDEX(COLLECT({Master Range Jan Column}, {Master Range SRC ID},…
-
Sum values from multiple columns when associated checkbox is ticked
Hi I am trying to use the IF formula to sum multiple column values if an associated column checkbox is ticked - basically duplicating the formula below to the other checkbox field and specific columns. It tried the "AND" function - without luck. Any expert able to assist? Thank you
-
Conditional formatting for reoccurring tasks
Hello, I am trying to design a task tracking smartsheet for tasks of varying reoccurrence, i.e., monthly, quarterly and annually. In this sheet, the idea is to use conditional formatting as a means to identify when something is past due (in the past, red), upcoming (in the next 60 days, yellow), completed (green) or in the…
-
Return the cell with a value from 3 cells
Good morning all, I can't get my head around this one so wanted to see if anybody can help. I have 3 columns: Downtime Start Time OOO Start Time Manual Downtime Start Time I would like a formula in a different column that searches all 3 of these cells and returns the first one that isn't blank. Is this possible? Thank you…
