-
Status Formula is not calculating correctly for parent tasks
I was trying to align my Health and Status columns, but the status formula is acting wonky.. (there's a technical term for ya! 😂) First a HUGE disclaimer. I'm not not new to Smartsheet, but I am new to this particular sheet. I inherited it, and the person who created this formula is out on leave until February. Here's my…
-
Managers Approval Matrix > Pull Which Level Manager is Needed + Skip to Next Level Manager if Blank
Hi All! I have manager level. I need to pull in the Employee ID (EID) for the Manager Level of Approver that each requires. And if it's blank I need to pull the next level approver. In the picture below, the two green circles highlight this. So if a contract value determines I need a Level 4 approver (already setup…
-
Index match formula but for specific values of column
Hi team, I have region, I'd and manager columns I am using index match formula to get manager updated from another reference sheet based on identifier I'd. But i want this formula to be applied for only cell with region as Asia for example How to achieve this?
-
Counting cells that are not blank
Hi, I need to count the cells in a column that are not blank. This formula is giving me an unparseable error: =COUNTIF({Date Converted from DataCor to Exp Lite}:{Date Converted from DataCor to Exp Lite},<>"") Thanks!
-
IF statement with returning value -> if value blank, place a zero
Hi, I am trying to fill in a row with numbers from a pivot sheet I created. If the pivot value is blank, I need a zero to be placed in the field the blank value is returning to: IF(NOT(ISBLANK(INDEX({Pivot sheet Active value range}, MATCH([Identity ID]@row, {Pivot sheet Identity ID range}, 0)))), "0"). This formula is…
-
Cannot convert to column formula
Hello, I've been banging my head against this issue and have not found a solution. I'm trying to convert a working formula into a column formula but keep getting a "not quite right" error. I thought other parts of the formula were incorrect so I removed them to see if that was the case but it's not. I know having an…
-
I have a parent row that needs to populate with appropriate 'Status' based on it's children
I have many parent rows with many children, in some cased grandchildren. Each child (or grandchild) has a status. Status choices are; Not Applicable Not Started In Progress Complete I have to account for the following possibilities; I have been able to write a formula for the first 4; I am having great difficulty writing…
-
Creating a Daily Total Sheet from another Sheet that Updates Daily
Hi all, I am having trouble finding the best practice for this and thought it might be easier to ask here. I have my "Main Data" sheet that gets replaced daily through a Data Shuttle workflow. I need to create a helper sheet that totals the count of one of the columns and keeps track of the totals for each day. For…
-
Linking External Sheets for Conditional Formatting
I am currently working on conditional formatting for a spreadsheet that connects to several spreadsheets. We have a Master Log (spreadsheet) that pulls project dates from multiple Project Schedules (Gantts) so we can keep track of project timelines of milestones. We have roughly 45 fields. 17 fields are linked to Project…
-
I am trying to create small chart for dashboard
I have a master sheet that has 100 projects all different end dates. Trying to find a formula or method create small chart like a sample Jan 2022 - 4 Feb 2022 - 3 Mar 2022 - 4 Etc...
