-
If date is less than, greater than, or blank formula.
I am creating a formula that will display Completed, Upcoming, or Prerecorded based on the dates in Column 2021 Session Dates. When I use the formula below, any row with no date comes back as Completed even though I have added the IF ISBLANK formula to output Prerecorded. I don't get an error in the field, just not gettingβ¦
-
Counting from two different date columns without counting twice
I have a report that is pulling data on traffic in the past week. I have two date columns, one is First Visit, and the second is Most Recent Visit. The report is pulling the rows based on whether one of those columns has a date between last Monday and this Monday. Im trying to make formula that does the same I also have aβ¦
-
Open Update Form - Restrict certain values from editing
Hi When you "Request an Update" in a workflow and the email is received by the intended party, is there a way to restrict which of the form responses they can edit when they're taken to the data grid? Currently they can amend everything that is in the grid but I only want them to be able to edit 2 new columns with theirβ¦
-
A formula pulling Time from a System-Generated column does not stay consistent. Please help!
I am using a formula to pull the time from a system-generated column using Created (Date). The formula is =RIGHT(Created@row, 8). A majority of the time is accurately pulls that correct information but other times it is off by two hours. For example, the screenshot is showing it accurately. But it will randomly switch toβ¦
-
To find out how many times the contact is mentioned
Hello, I know the subject has already been mentioned but I can't solve my problem. Because a cell can contain several contacts. I am trying to find out how many times the contact "Franck Debucquet" is mentioned in a column. Sometimes a cell can contain several contacts. See example below : Thanks !
-
Counting how many sales were made this week, starting the count from Monday
Hi! I would like to count number of sales , depending on the date that the sale was made. Also the week should update every week, and I've found this formula: =COUNTIF({Sales Data}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY())), and it works, but is there something else I could add to it so that it will startβ¦
-
Zeroes after decimal point not being extracted
Having issue with decimal numbers. I'm trying to extract the numbers after the decimals, but if it's a whole number, it doesn't recognize the zeroes and just gives the value before the decimal point. Anyone have a solution for this? The value I want to get out of the above formula is the 00 The reason I need to extract theβ¦
-
How to connect statements with conditions?
Howdy! I am new in the business and i'm trying to connect some statements on my sheet, so I'll apreciate if anyone can help me with this :) =IF([PROGRESS]2 = 1, "Green" (Status) Now IF today is greater than one day of the [due date]1 , "Red" IF [STATUS]1 IS GREEN should be green even if due date is greater than "today"β¦
-
How do I make my range reference stay the same throughout the sheet?
For instance, I have this formula: =SUMIF([Week Number]1:[Week Number]68, 4, Quantity1:Quantity68). I need to use it multiple times but changing the criteria value (in this reference, this "4", which I will change manually based on the number I am looking for). But each time I either copy/paste or drag, it changes theβ¦
-
How can I use COUNTIF to count rows?
I am linking a report with another spreadsheet and each row in the spreadsheet is labeled either Facebook or Google. In my report, I need the total number of rows for Facebook or Google in order to figure out other calculations for my social media report. I have tried using: =COUNTIF({Social Media Data 2021 Range 8},β¦