-
COUNTIF and HAS
Hi I'm trying to find the best way of counting particular options from a drop down list on another sheet by a certain date. The formula I have so far is: =COUNTIFS(HAS({Job Log l Job Type}, "CD Creation"), HAS({Job Log l Job Type}, "CD Extraction", HAS({Job Log l Job Type}, "Scan & post", HAS({Job Log l Job Type}, "USB…
-
MEDIAN() Column formula keeps breaking.
Hello Smart people, I have a solution that uses four sheets. The first, is an export of vehicle assignments from a vehicle management system. Data Shuttle overwrites all data in this sheet at 12:00AM each day. The second sheet (Daily Rental Summary), is a sheet to aggregate daily totals. A workflow adds a new row to this…
-
Scheduling for Resource Availability
Hello, I have a sheet for users to enter requests for our quality department. They chose a type of task they need, i have a VLookup assigning how many hours to assign to that row based on the task. That all works fine. But I need to find away to factor in the staffing restraints for each day and push some tasks out if too…
-
Which formula to use to set conditional rules between 3 columns in a sheet?
Using formulae in sheets, I am trying to create a template for Stakeholder mapping by embedding the below conditions and results. For Instance If (1) is entered in Column A and (B) is entered in column B, column C should pull in "Keep Informed". Or if (2) is entered in column A and (C) is entered in column B, column C…
-
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.
