-
Incrementing a Number by One for Each Time a Status is Selected
I have a sheet where we have a variety of values in a Status column. I am looking to have a separate column that would count how many times a row has gone through a particular status (" Revise") so we can see how many rounds of revisions a particular project goes through. We were going to call it "# of Revisions". The…
-
Returning a Date Value from Another Sheet if Certain Criterias are Met
I have been working on the formula to return a date value from another worksheet if certain criterias are met. Here is the formula i input but with a formula error of #UNPARSEABLE =INDEX(COLLECT({Send Out Date}, {Range}, =CONTAINS("Bank Confirmation", {Range}), {Client ID1}, =CONTAINS([Client ID]@row, {Client ID1}))),1)…
-
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…
