-
add data with hours - formula or something else
Como que eu faço para somar datas com horas exemplo (18/04/2023 15:00:00 - 06/04/2023 13:00:00 ??) Translated by Moderator How do I add data with hours for example (04/18/2023 15:00:00 - 04/06/2023 13:00:00 ??)
-
COUNTIF with HAS or COUNTM for Report
I'm making modifications to the marketing request template set. There is a report that ties back to the intake form. The intake report overtime adds a count of 1 to the assignee for each project completed by the assignee for each month. The issue I am having is, if there are multiple people assigned to the filed the count…
-
Formula help : Identifying most recent row that meets specific criteria
I am recording contents moving between sites based off a SKU. I want to write a formula in the column shown below "Most Recent" that will identify the row as the most recent row for that specific sku. I'm guessing I need a max or collect formula but can't quite figure out how to write it. Concern with MAX - I could have 5…
-
COUNTIFS w/ multiple criteria (date present & phrase inclusion) across 2 ranges in same sheet
I am a relatively new user, and I'm struggling with the creation of a COUNTIFS formula that checks one range/column to determine if a particular phrase is present, followed by a second criteria to determine if a date is present (or entry not blank) in a second range on the same sheet. The entries in this combined formula…
-
Adding "OR" to a function
Hi there - I have quite a complicated formula, and I'm having difficulties integrating an OR statement. The below formula works great, but I need it to find "David" OR "Chuck", where it currently is only finding David. =SUM(COUNTIFS({MASTER TRACKING SHEET Range 3}, "CD", {MASTER TRACKING SHEET Range 2}, FIND("David",…
-
Countif Date Formula
Hello, I'm having an issue with a countif formula. I'm trying to countif the number for submissions that happened within a specific month on another sheet but keep getting an #INVALID DATA TYPE. I checked the column type in the other sheet and it is a date column. The formula works in the actual sheet with the data, but…
-
Formula for accurate turnaround time
Hello Community! I'm a relatively new Smartsheet user and inherited a very large sheet that we use to manage the status of our contracts. To calculate our current turnaround time, we are using the following formula =[Date Sent for Sig/ Date Returned]@row - [Date Sent to Review Team]@row. While this works, we are looking…
-
Moving certain columns to a new sheet based on criteria
Is it possible to move only certain columns to a new sheet based on certain criteria? For instance, when an employee is terminated, I only want to move his name, termination date, and department to the offboarding tasks sheet rather than moving the entire row with so much information not needed for this sheet. I realize…
-
Formula for calculating Current Date/Status and Expected end date
I am trying to get my Status Column to be the following colours below based on the criteria. Grey = Status is “Not Started” Yellow = Status = “In Progress” and current date is less than expected finish date Red = Status = “In Progress” and current date is greater than expected finish date Green = Status = “Completed Any…
-
Calculate multiple or range in formula
Hello, I have created a sheet that reflect Projects end year and I'd like to count certain years. I have the following formula: =COUNTIF([Year Closed]:[Year Closed], "2023") that works well. How do I calculate multiple years like 2022 & 2023, or a range 2020-2023 in one formula? Thanks! Tali
