-
Multiple Countifs Using Symbols
I am not an advanced formula user. I want to find the count of records that have multiple criteria. The formula I'm using now returns a value of 3, but should be 9. =COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, <>"Low") I have a symbol column in my Action Item page…
-
Countif with Median
Hi there! I am trying to gather the median for a set of numbers but only if it falls in a certain category. I have a formula used in the column I am pulling the median from, and in instances where I don't have all the data, the cell defaults to 0 (as i am using a division formula) which skews the median. Example: I want to…
-
Fix Incorrect Argument Set when Matching Max Values
Hi! I'm trying to return a number value from my "Score" column in my sheet summary. The Score I want is whichever one has the latest date in the "Score Date" column. To accomplish this I'm trying to use the following formula: =INDEX(Score:Score, MATCH(MAX([Score Date]:[Score Date]))) I'm getting an incorrect argument set…
-
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!
