-
COUNTIFS & ISDATE FORMULA
Good Afternoon, Hope you are safe in this winter weather. MY FORMULA is unparseable: =COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")) The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY…
-
How to Phrase a Question for the AI or Write the Formula for Myself for Grouping Data
Hello, I would like to see if anyone can help me parse entries across different columns. What I have in my SS is a list of registration numbers in Column A and departmental associations in Column B. I would like to count how many different registration numbers appear in Column A and then group them by their departments in…
-
Calculating Time in Smartsheet
Hello. In excel, I have a formula that calculates the departure time of a coach from point A by taking the arrival time (a variable I choose) and subtracting the travel time. I then have a formula that subtracts 15 min from the departure time for the load time. The final formula subtracts 15 from the load time for the spot…
-
Date Based Automation Did Not Send Automated Email
We have a date-based automation that sends an automated email to our employees. The automations trigger is "When a date is reached" and that date is the date in a specific cell. The date in the CLIN 2 First Reminder cell is a date that is calculated by a formula. The formula looks at the hard-coded date in the CLIN 2…
-
Automating Email Alerts for Multi-Stage Document Review
Hi, I’m looking to set up email alerts for two stages of a document review. I’ve currently configured IF functions so that, once the ‘Document Received’ checkbox is selected, the status in the ‘Primary Review’ column automatically changes from ‘Not Started’ to ‘In Progress’. Stakeholders then tick off the relevant boxes in…
-
COUNTIF & ISDATE FUNCTION
Good Afternoon All, I hope you are stating safe in this winter weather. I have a formula but to no avail I am getting unparseable. I want my COUNTIFS function to count only if there is a date in column (DEACTIVATE TIMESTAMP YR 5) = ANY DATE and count only if the specific criteria from on column (DEACTIVATE TIMESTAMP YR 5)…
-
Return blank when count total is zero
Can you give me a variation of this formula that delivers a blank if total counted is 0? I want to use it in forward months so I don't have to update the metrics sheet monthly, if possible. Thanks, Lisa I tried the IFERROR and IF(COUNTIFS( I could find but most deliver Incorrect Argument. =COUNTIFS({4Q2025 FPG thru Oct…
-
Rolling View - Timebound
Hi community! I'm trying to figure out a way where a report will filter and pull based on a time frame. I have a sheet where all of our cyclical events are listed with start/end dates. I want to provide a way where only current events (in progress today) and going through next 3 months are pulled. Suggestions on how to…
-
Counting Specific Items within an array where row meets criteria
Hello, I am trying to count specific text within and array: Basically, I am trying to count the number of times Testing occurred in the last 2 weeks, so using either a specific date or the check box. I will also expand this to specific people that is not shown in the screen shot. I have the formula to count the array, but…
-
Pull most recent date from another sheet based on two criteria
I am trying to pull the most recent date that a recurring job. I have the facility where the work was conducted, the last day of the job and the job category on the other sheet. I need the category section of the formula to look for a word contained within the text.