-
HELP! How do I get row updates from a request copied to another sheet?
Hi Team, I'm new to Smartsheet and initially created a build that may not have been the best. I built my request management master sheet and copied requests to Department 1 for assigned PMs to work. Unfortunately once the row was copied, the master sheet was not updated. Now projects have ended (and moved to either a…
-
Good Afternoon, I have a formula below and it returns 0 values.
=COUNTIFS({Project Portfolio Tracker PM}, "Jane Smith", {Project Portfolio Tracker Range 8}, "In Progress", {Project Portfolio Tracker Range 8}, "Not Started" ) Can someone please advise me on what I am doing wrong? Thanks, Scott
-
formula to create email address
Hi I'm new to using formulas. How can I create a formula to populate someone's email address into another box? The email address would be the first initial of their first name Last name @ our company name. Thanks for any direction to where I can learn to do this.
-
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…
