-
Incorrect argument set error message on countif formula
I'm working on a project that distributes free car seats and we collect data from family members for up to 4 children per family depending on their car seat needs. One entry may include 1, 2, 3, and/or 4 children and we ask for specific demographic data per child. Again, all collected in entry so across multiple columns…
-
Updating Date with new year.
If Inspection Due Date is required every year in October and this year the inspection did not take place until December, how can I write a formula to send reminder every year 90 days before required date of October, not December. And how do I get the required October date to update with each new year so the automation…
-
showing today's date + an offset in a form
I have a need to create a form that asks for user input and is for the purpose of collecting information about a desired project to be completed by our team. We want to allow the user to see a default due date that is X days from the day they are submitting the form. I've seen various posts here that lead me to believe…
-
SUMIFS with Reference Columns?
Hi Everyone, I am stuck on a scenario that I need assistance with. I have a sheet to track project tasks. (screen # 1). In this sheet, I have a formula to calculate hours per person per month and it works great. I would like to move this formula to a helper-sheet (screen # 2) so I can run reports on it. However, when I…
-
Update Row from Info of Another Sheet
I have a Tracker which my team updates if they have done it. The row is unique to specific individual name or employee ID. When a teammate updates this row by checking the checkbox, I want another sheet to mark it with check too, that matches the criteria of the name/employee ID. Please help. Thank you!
-
Determining Count of Items in a column based on Specific Dates
As the title suggests, I am trying to determine the number of Active Projects, based on status, on a monthly basis. I am not basing my logical expression based on a date criteria in a cell; I simply want to see: Active Projects (based on a status of: Not Started, In Progress, On Hold) Jan 01 to Jan 31 (as an example; would…
-
IF/HAS multiple Columns
I am running the IF/HAS script to check if a customer is in a column/list. However, I would like to expand that search to include another column from another sheet. Works: =IF(HAS(CustomerName:CustomerName, Customer@row), 1, 0) Not working: =IF(OR(HAS(CustomerName:CustomerName, {Master Customer Sheet Range 1}:{Master…
-
Countifs, Date Functions and Text Criteria
I am putting together two sets of formulas so I can capture the number of tasks within a certain year and month, and another set to see which of those are completed. My formula that works to capture the number of tasks is (in this example, January 2024: =COUNTIFS({GA Date}, IFERROR(MONTH(@cell), 0) = 1, {GA Date},…
-
Conditional Formatting - If date entered is prior to another date
I'm looking for a way to set conditional formatting to a date field on our Smartsheet. Currently we capture "Date Submit Legal" and "Date Legal Approved". I would like to find a way to change the font to red if the approved date is prior to the submit date. Since this is a manual field we are finding on occasion the date…
-
Row Shading formula - how to make it work?
I tried to apply the row shading formula to my sheet but it didn't work. Do I have to enter the ISEVEN/MATCH formula to each row? every other row? on the sample exhibit, it only shows the formula on the third row which I copied. Do I have to manually check every other box? Should I convert the shading column to formula so…