-
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",…
-
Bug with Cell Links?
Hi all, I'm using Smartsheet Gov and cell linking out from one source sheet pretty extensively, and I'm running into an intermittent issue where the cell being linked to will return what looks like a data structure containing the element I want, instead of just the element itself, e.g. ["A"] instead of A. Here is an…
-
Column Formula pulling from 2 Columns on 2 Sheets
This discussion was created from comments split from: COUNTIFS: Column Formula pulling from 2 Columns on 2 Sheets.
-
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},…
-
How to calculate resolution time?
I have a sheet, where via form the Project team submits a Change Request. I need to calculate how long it takes the submit the request until it's marked Approved. We are trying to calculate the resolution time So I have a column called " date of creation" and I have another called "Last review". which will make it easier…
-
Display Running Total of Days
I have a dashboard that displays various totals, I would like to have in the corner a running total displaying "# of days" since opening day. So when someone opens the dashboard they can easily see Stats for 10 days, then 11 days, then 12 days... so they can then do there own stats... Note while we are in operation 7 days…
-
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…
-
Linking Construction Program line items to relevant task lists
I'm working for a design and construct fit out company and we're looking to invest in control center and I'm just looking at the configuration of the project workspaces and need some ideas for the following scenario.... Each project has a construction programme which is shared with the client. Within that program there are…
-
Workaround for changing values available to select based on what's selected in another column?
I'm needing to be able to provide a 2 columns, both with drop down lists, but the 2nd column needs to change the available values differently based on what's selected in the 1st column. I've seen online where this is not possible with a trigger of add a new row in workflows. I'd love to be able to point the selections to…