-
Wondering if anyone knows how to set up a certain work flow and/or formula...
I am trying to adjust one of my sheets/create a new workflow or formula to highlight the group name or entire row if someone does not submit a new check from the forum link within 90 days from the last check they submitted. So how I currently have this set up, is there is a sheet created and then we attach the forum link…
-
Vertical results with join collect
Hello! I am working to pull in multiple employee names from a master file based on the facility they work at. I used the following formula. =JOIN(COLLECT({Job Categorization Range 2}, {Job Categorization Range 1}, [ADP employee ID (formula)]@row), " / ") I am looking to populate the data into a smartsheet form list…
-
Calculations and Dashboard Data based on WeekNumber
I've been asked to create a PM tracking system. All the tasks for the year are in one sheet with each task having a row. I a summary section that feeds a dashboard with data showing data points, charts, and reports based on the month and completion status. The colleague came back with request to revise the dashboard with…
-
COUNTIF with AND
I've written the statement but am getting a #INCORRECT ARGUMENT SET error. I'm new to SS, any help is appreciated. =COUNTIF(AND([Opportunity Risk Path]:[Opportunity Risk Path], [Module Approval Status]:[Module Approval Status], ="Conventional", "Not Started"))
-
IF CONTAINS Formula to return different text values in second column
Hi! I am looking for some help in creating a formula where if a certain word is found in one column, another word is returned in a second column. For example if "Head", "Nasal", or "Spine" is contained in the Procedure column, "Neuro" is returned in the Clinical Specialty column. I've tried different variations of this and…
-
Conditional formatting to highlight tasks due each week
How can I set my conditional formatting to show tasks that are due for the current week? I schedule recurring tasks out in the future but I want to hone in on the tasks for each week. For example: Any day this week, I want to see only Monday, June 5 - Friday, June 9
-
How to I calculate percentage progress in sheet summary based on status?
How to I calculate percentage progress in sheet summary based on status?
-
Using the CONTAINS function
I am attempting to add a search criteria to an existing function. The current, working function is =SUMIFS({Total Seat Count}, {Region}, ="US East") + SUMIFS({Total Seats Archive}, {Region Archive}, ="US East") I would like to create a new function that will specify a count with a specific unit name "VFX" found in the…
-
Smartsheet Formula Reference to another sheet
I am creating several different budget sheets. In these I want to reference one reference sheet. For example in my current sheet: I am looking to say If Column names: HI Rate Code = HR Rate Code from sheet name: Reference Guide then bring over the # listed in Sheet Name Reference Guide, Column Name: HI Rate Amount. Help :(
-
Networkdays Help/Issue?
Hi, I have a formula that for networkdays: Here is the Formula. =IFERROR(NETWORKDAYS(TODAY(), [Due No Later Than]@row, Holidays:Holidays) - 1, "NA") However, anytime the days goes to negative it instantly goes to negative 3 (-3). So the calculation shoots from 0 to -3 the when the day shifts even though it should be -1, So…