-
COUNTIFS date range in Date Column with blanks
Hi, I have a date column with blanks that I'm trying to get a count of cells that contain dates by quarter (Jan-March, April-June etc.) I tried this: =COUNTIFS([Helper Date]:[Helper Date], AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31))) But the result is "0" I looked through the community and I tried playingโฆ
-
With required text fields; how do avoid people entering in a "blank" or "period"?
Is there a way to put validation on required text form fields to avoid folks entering blanks, periods or random characters?
-
30 Day look back
Hello, I am using the formula below to count all instances of rows that contain "ADCVD" in my "2022 Archive RFI Reason" with my "2022 Archive Created Date Range". My problem is that my Jan 21 data is located in in my "2021 Archive Created Date Range" sheet. How can I modify this formula to look back 30 days in bothโฆ
-
Countifs plus a date range?
Hello, My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc. How do I write the formula for the date so that it includes all days of each month? =Countifs [Adjusted Due date]:[Adjusted Due Date],โฆ
-
Index/Match formula not working
Hey community! I've been using this Index/Match formula for a while now and suddenly, when I copy/paste it into a new sheet from my template sheet, I am getting an #INVALIDREF error. I didn't change anything and I have confirmed that it is pointing to the correct references so I don't know what is going wrong. Is thereโฆ
-
Inserting contact name based on dropdown menu choice
Hi folks (but especially @Andrรฉe Starรฅ ๐!), My next query is around inserting contacts based on drop-down choice. Certain departments will be attached to a task and once they are chosen, I would like a column to change to a relevant colleague contact. Again, I had a crack at an IF statement and got this far: = IF([Assignedโฆ
-
Drop Down List Matching Formula
Hi, I have two columns and each column has a multi drop down box. I have been trying to create a formula that will return a date in a 3rd column when the first two columns drop down list match. Any assistance is appreciated.
-
Index/Collect with a date being one of the criteria
Hi, I'm trying to write an index/collect formula and one of the criteria is that the date is yesterday. I'm having trouble. Any suggestions? =INDEX(COLLECT({Evergreen Totals}, {Admission Type}, "Start of Business", {Date}, TODAY() - 1, 1)) Thank you!
-
Formula not working in Smartsheet when data is populated from form
I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form. Thankโฆ
-
Will the changing of linked cells not trigger automation?
I have two sheets with linked cells. In the sheet that receives the linked information I have two automations set up to change other cells on the sheet based on the linked information coming through, but nothing is happening. When I manually change the cells (overriding the links) the automation happens, but not when theโฆ