-
Counting multi select column that is also contact list
I have Contact list - multiple resources can be assigned task I want to count the number of times a particular resource has been assigned a task. I've tried these both: =COUNTIF({Staff Actions Range 4}, HAS("Joe X", {Staff Actions Range 4})) =COUNTIF({Staff Actions Range 4}, CONTAINS("Joe X", {Staff Actions Range 4})) Both…
-
Smartsheet for Pandemic Readiness- Dont Panic Prepare!
IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available information are complicating the situation as individuals and organizations seek to…
-
Report from multiple sheets - but automatically including new sheets
We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information from each sheet in each WorkSpace (so across sheets), but also have it add new sheets as new Workspaces are created. Is that…
-
Combining Two Formulas in One Cell (NETDAYS and Addition)
Hi everyone, I am looking to combine two formulas in one cell (one to calculate number of days; one to calculate completion date, using calculated days). The information below was provided to me by my supervisor to use, but I have been struggling to come up with a solution. Here is the information: Formula: First Product…
-
How to change status based on start/end dates/if completed was checked or not.
Hi there, I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figuring out how to create a formula where if start date is in the past and end date is in the future, having it automatically…
-
I want to do a serial IF this then that formula across more than one column. Please help!
My =IF(Child@row="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example, In the Parent Column, I want to combine =IF(Child@row="Name1", "Parent1"), OR =IF(Child@row="Name2", "Parent2"), OR =IF(Child@row="Name3",…
-
Need to tweak Health Indicator formula based on "status date"
I need to tweak the following formula to use a [Status Date] instead of "Today". We publish status reports each Wednesday as of Friday of the previous week. I have added a Status Date column that I will update each week to reflect the status date. Current formula; =IF([% Complete]@row = 1, "Blue", IF([Planned Duration]@row…
-
Date formula help: return 90 days earlier than start date, on the closest Tuesday
Hello, I'm looking for a formula to pull a date that is 90 days earlier than our start date but on the closest Tuesday. Thank you
-
IF Statement - Checkboxes
Hi there, I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field is left blank and the Status is "In Progress" the checkbox is marked off. I want to make it so if…
-
Seven Most Current Entries for each Question for Each Location
Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. This is the formula I started using based on responses in the community: =INDEX({TEST Range 2}, MATCH(MAX(COLLECT({TEST Range 4}, {TEST Range 2}, [Q1]@row)), "Clearfield", {TEST Range 5}, 0)) This formula…