Formulas

DATE(2023, 6, 1), [Date Closed]:[Date Closed], \"\" and [Bug or Request]:[Bug or Request], \"Bug\" I tried…","categoryID":322,"dateInserted":"2023-08-01T16:49:25+00:00","dateUpdated":null,"dateLastComment":"2023-08-01T17:13:01+00:00","insertUserID":139576,"insertUser":{"userID":139576,"name":"K Miller","url":"https:\/\/community.smartsheet.com\/profile\/K%20Miller","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hAtpoYJ45_M!Dl1TQ0DO0iQ!MPp8IQrC3KR","dateLastActive":"2023-08-24T19:06:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":139576,"lastUser":{"userID":139576,"name":"K Miller","url":"https:\/\/community.smartsheet.com\/profile\/K%20Miller","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hAtpoYJ45_M!Dl1TQ0DO0iQ!MPp8IQrC3KR","dateLastActive":"2023-08-24T19:06:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":79,"score":null,"hot":3381819746,"url":"https:\/\/community.smartsheet.com\/discussion\/108361\/countifs-contains-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108361\/countifs-contains-and","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-01T17:51:41+00:00","dateAnswered":"2023-08-01T17:08:09+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

'Most Common' Formula
Hello, I am trying to create metrics on tracking the versions of an applications we are developing, currently I am attempting to find which version is most successful after it has been run through a series of criteria. Example: Build 30 - Success Build 31- Success Build 31 - Failure Build 32 - Success The Application…
Working Days across a Date range
Hello friends! I'm hoping to have a column which automatically populates the number of working days in a given period from a [Start Date] and [Number of Months] columns. e.g. Start Date = 3rd July 2023 Number of Months = 2 Result = 45 days 63 calendar days – 18 days skipped: 9 Saturdays, 9 Sundays Would anyone have a…
Auto Populate a date if another cell contains specific text
So I am sure this has been asked, but i cant seem to find anything on this topic. I am looking for a formula that will auto populate a cell with a date if another cell within that same sheet contains specific text. Example: If [Assignment]@row, HAS "Audit", then place a date in [Audit Due]@row Searching for Specific Text…
NETWORKDAYS
PROBLEM SOLVED THANK YOU
IF CONTAINS Help!
Good morning, I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.…
How to return a MAX Value of "0" if Remaining # of Weeks is < 0
Hello Amazing Community, I'm trying to create a formula to Remaining Number of Weeks on a project. Start Date = 5/30/23 End Date = 6/15/23 Formula for Remaining # of Weeks (from today) =NETDAYS(TODAY(), [End Date]@row) / 7 = -2.9 **Problem is when End Date is in the past, and TODAY keeps changing, in which case, Remaining…
Countif specific type and year
=COUNTIFS(Type:Type, ="CTA New"), ([Date Submitted]:[Date Submitted], IFERROR(YEAR(@cell), 0) = 2022) I've been looking at examples of this question all day - but for some reason I can't make my formula work. The above formula is #Unparseable. I want to count the number of rows with "CTA New" Type and 2022 Date Submitted…
Total time-off days by year
I am having trouble creating a formula on my Staff Total Days Off sheet that pulls information from my Time-off Request Log sheet but for a specific year. Sheet 1: Time-off request sheet tracks each employee's approved time-off dates and days with an additional column for YEAR of request. Sheet 2: The Total Days Off sheet…
AverageIf与多个标准
I would like to find the Average Resolution time (Days) for rows where the date closed is in June 2023. =AVERAGEIF(AND([Date Closed]:[Date Closed], >DATE(2023, 6, 1), [Date Closed]:[Date Closed],
COUNTIFS+CONTAINS+AND
I am trying to write a sheet summary formula to count the number of rows where: Sprint Name contains "Maintenance", Date Resolved is not blank, and Bug or Request equals "Bug" [Sprint Name]:[Sprint Name], CONTAINS("Maintenance") and [Date Resolved]:[Date Resolved], <>"" and [Bug or Request]:[Bug or Request], "Bug" I tried…

Formulas

Discussion List