-
Comparing cells in two columns
I need to compare two date columns. If Column A contains a Date and if column B does not contain a date then count, otherwise 0. I have tried =IF(ISBLANK([Date CMI filed in compliance]@row), IF(NOT(ISBLANK([Date form sent to FE]@row), 1, 0))) but it is returning an incorrect argument, can anyone help me please?
-
Pull data from one sheet to another when a box is checked.
Hi SS Community, I'm trying to figure out the best way for data from specific columns in a sheet to get copied to cells in an control center intake sheet. Thanks, Kyle
-
Setting up Automation to "Request an Update" from a contact within the row.
I am wanting to set up an automation to request an update to a specific field from the person whose email is in the row. How do I do that? I have selected "Send to contacts in a cell" but the only dropdown option I have is "Modified By." I would like to send it to a different Column Header: "email address". Is this…
-
CONTAINS: What's it all about and how does it work?
I personally am still getting used to the new CONTAINS function, and I have noticed a few others on here looking for clarity. I figured I would start this thread in an effort to hopefully combine knowledge and do some collective brainstorming on how it works and some good examples of use cases. I'll be revisiting this…
-
Formula to count rows in a report
On a sheet, is there a way to write a formula to count how many rows are on a report. We have many reports and would like to know how may rows are in each report on a single sheet.
-
Nesting IF(AND with an OR, evaluate multiple conditions to check a box
Hi all Currently using the following (resides in a checkbox column) that is working perfectly for a project to tag items that are then pulled into a report. =IF(AND([End Date]@row <= TODAY($HuddleDays$1), [End Date]@row >= TODAY(-4)), 1, 0) I've found that if an items happen to have a [Status] that is <> Complete and falls…
-
Help on Intake Form
I am wanting to use the Project Management Office Template to create a PO System Template instead. On the Intake Sheet I can change the column headers. But I cannot change the First Row Title Cells. They are tied to the Metadata Sheet in the Template. I want to know how to change these to reflect the titles I need, such as…
-
Remove spaces from text string
In a column that I've titled File Name, I've created a =JOIN formula that merges multiple columns of information to generate a consistent set of file names. One of the columns that is being merged shows the title of an item with spaces between words (e.g., in the Title column, one of the titles reads: Curriculum…
-
SUMIFS returns a $0 (s/b an amount) once there are Oct 2022 & 2023 entries in a date range
Aloha, I have a SUMIFS formula that works until I have Oct 2022 and Oct 2023 entries in the date range. Then Oct 2023 returns a $0 when it should return an amount. I have tried reversing the month and year in order in the formula and it still returns a $0, any help would be appreciated. =SUMIFS(Price33:Price174, [Expected…
-
Formula for IFERROR(Index(Collect based on 3 different unique columns.
Good Morning Smartsheet Community, Current Formula: =IFERROR(INDEX(COLLECT({Pass/Fail}, {Sales Order Number}, @cell = SO@row, {Unit Part Number}, @cell = Part@row), 1), "") Possible New Formula: =IFERROR(INDEX(COLLECT({Pass/Fail}, {Sales Order Number}, @cell = SO@row, {Unit Part Number}, @cell = Part@row, {Line Number},…
