-
Separate multiple cells by delimiter into multiple rows
I am trying to develop a WFH schedule tool. I have a form that asks managers to check boxes for Week X starting on X Monday Date which days their team will be in the office. Then I have the formula to convert the check marks into TEAM NAME Date + ","... On another sheet, I'm trying to convert the text created in COMBINE…
-
CountIF to look for a partial piece of text
Hi all, I'm looking to use Count IF to look for piece of a text from a different sheet. I've tried the following variations with no luck: =COUNTIFS({QA WORKLOAD Date}, "BACKLOG", {QA WORKLOAD Com/CT}, "COM", {QA WORKLOAD WO ST}, "99", {QA WORKLOAD Description}, CONTAINS("SUB", @cell})) =COUNTIFS({QA WORKLOAD Date},…
-
Input form for multiple sheets
I originally had an Excel worksheet with multiple tabs. The first tab was an input sheet which fed into 100's of formulas in the other tabs. The other tabs (one for each country) used the values from the input sheet to do the numerous calculations. In Smartsheet, I imported each tab (input sheet and each country). I also…
-
Number& type of comms per target audience
Hi ! I am completely stuck. I have columns: Target audience (ie: managers, employees..) Channel (email, meeting ..) I managed to calculate the number of meetings, but I have no clue how to get to number of meetings per targeted audience. Is this even the right direction? =COUNTIFS({channel},Meeting,{Target…
-
Formula for Join, Collect, and If Statement - Resources Availability
I have a sheet that contains my resources' availability for each week and I'd like to pull in a list of those that have availability into another sheet so we know who to assigned to tasks on a project. I figured out the Join(Collect) part of the statement but I need to get the IF statement to work. Please see below for how…
-
IF used in MAX COLLECT?
Hi Our Jobs done sheet is populated through a form to give. We must make 2 visits contracted visits a month. However, sometimes we are called out for a repair. I have a sheet that calculates the days since we carried out a site visit. Date attended =MAX(COLLECT({Jobs Range 2}, {Jobs Range 1}, site1)) range 2 = Date. Range…
-
Use Formula to Assign Dropdown Selection in Column
I would like to have the column titled Alert Level return a symbol from the dropdown menu based on the number of selections in the Alert column. I'd like the symbol to be green if there the Alert column for that row is blank. Blue if there is 1 item in the Alert column, Yellow is 2 items and Red if there are 3 or more. Is…
-
Sheet Summary Formula
The above image shows the three highlighted columns I am working with in the Sheet Summary section. If I just calculate the value by subheading, it works well but I need it to identify the status: =SUMIF(SubHeading:SubHeading, (CONTAINS("Small Works", @cell)), Value:Value) What I want my formula to do is to sum total the…
-
Im trying to show latest cell value
=VALUE(RIGHT(January11:December11)) I am trying to show the latest value for the most recent months entry so it can rll up to my dashboard.
-
Baseline Start & Finish "Parent Dates" not reflecting correct first / Last children date
Hello @Paul Newcome, I've seen your reply in one inquiry related to my inquiry, but his is about dates being assigned to children tasks. I am using one of the available templates as below. I noticed that the parent baseline dates do not capture the correct earliest date as parent baseline Start date, and the latest end…