-
Contains Formula
Hello, I am trying to make a CountIfs formula that counts across a different spreadsheet, on if the comments cell contains the words "Moved", "Delayed", "Rescheduled", "Canceled", then output the number of these delayed cells. Having some trouble getting this to work as I think an OR statement is nested somewhere in here.…
-
COUNTIF worked 1st time but not the 2nd time
I'm a bit confused with a COUNTIF formula that works for one scenario but not another. I have a sheet summary report counting values in columns I'm counting how many check marks in the column "1st AE follow up" for each person so for example my formula for Rhonda is: =COUNTIFS(AE:AE, "Rhonda lastname", ([1st AE follow…
-
Countif Formula based on Column
I am looking to find a formula that will count if it is a quarter column. My sheet has columns - Fiscal Year, Quarter 2/3 (etc.) and then Monthly breakdowns. FY1 Total | Q1 Total | Jan | Feb | Mar | Q2 Total | Apr | May ... And continues on for a couple of FY. I want to get a count of how many quarters have a value in it.…
-
Completed project in a month
how to count completed projects within a data range. This is the formula I have: =COUNTIFS({Project Plan-700 Range 2}, "Complete", AND({3C-Database 700 Range 2} >= DATE(2022, 4, 1), {3C-Database 700 Range 2} <= DATE(2022, 4, 30))) thanks
-
IF AND
I am trying to narrow my conditional formatting for an order dependent on 2 different parts--- I created 2 condition columns for a line item, First Condition Column "Y/N" and Second Condition Column "Y/N" ...and in a third column "Required" I simply want and IF/ AND formula to say IF First Condition Column is "Yes" and IF…
-
SUMIFS & COUNTIFS with 2 Criteria
I'm trying to work on COUNTIFS first. It seems if I can crack one the other is pretty close. The riddle: =COUNTIF({Post Repair Count}, ({Domestic/Asian}, "Domestic")) I've tried COUNTIFS with the 2nd range but seems that the criteria for range 1 is tripping me up. {Post Repair Count} has no criteria to it. Just need to…
-
How to reflect correct date from "dateonly" formula.
Hello, In the attached image, I have an auto column "Modified" base on user entry / modification of a row. The "Date" column is formatted as a date entry with a formula of "=dateonly([Modified]@row)". The formula works, however, the 04/11/22 dates are not reflecting the proper date of 04/10/22. The only thing I can think…
-
Right and MID formula to pull from details sheet
I have imported my excel budget and details sheets into Smartsheet and unfortunately my formulas don't import correctly. I have struggled with rebuilding my formulas from excel to Smartsheet and that is the case with the below: =RIGHT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),5) How do I rewrite this in…
-
Need some help with syntax for if formula that also contains left statement and references other sma
Good afternoon! I am trying to grab some data from one smartsheet and populate into another smartsheets based on a few filters. Smartsheet 1 Workstream column must be Curriculum & Advising The left most 4 characters in the Objective column must match the Objective column in Smartsheet 2 If those two conditions are met,…
-
If checkbox is checked, add text to cell
Hello, I have a checkbox in a column named "Completed" I'd like to have a formula that adds the number "100" to a column named "% Complete" if the box is checked. I've read other posts and cannot get this to work. thanks!
