-
Compare dates in the same row but different columns
Hi all, Im looking at counting the number of times two date columns differ within the same row For example Column 1 Column 2 11/2/20 11/2/20 11/4/20 14/11/20 11/3/20 11/3/20 25/5/20 12/6/20 In this data the answer i am looking for is 2 as row 2 and 4 both differ, whereas in row 1 and 3 the dates are the same in both…
-
Automation: "Lock rows" command doesn't work
Hi, I have an issue with automation on one specific grid. A simple automation to lock a row when the status (status is a link from the project schedule) is set to "Closed" I added a message to it to see if the automation is triggered and I get the message but the row stays unlocked :( Any thoughts? (This kind of automation…
-
Counting cells with no blanks in a child column for multiple parent sections.
I have students(CHILD) categorized by University (PARENT) on one Smartsheet. I want to get the total number of students for that school in my sheet summary field. I was able to reach this with this formula. Here is an example of my Smartsheet: =COUNTIFS(CHILDREN([Schools]1), NOT(ISBLANK(@cell))) Answer: 2 which is CORRECT!…
-
Workflow not Triggering
I have a move workflow that should trigger when a checkbox is checked. The checkbox (picture below) has the column formula: =IF([Row#]@row > 50000, IF(IFERROR(MATCH([Row#]@row, {QC_Results_DB Row#}, 0), 0) > 0, 1, 0)) This formula triggers correctly, and checks the box when it should. The issue is that the workflow isn't…
-
Predecessors & Duration - Shifting a MUST END BY date
I am working to improve our project sheet. It is currently only able to be viewed in Grid view. It would be helpful to see in Gantt or Card view our teams timeline/schedule. This is a very large project sheet. I have a Start and End by Column with a Tech Assigned Column. Each Project (parent row) can have several sub…
-
Sheet summary sum function
The column I am attempting to sum is using a cross sheet reference to pull data in from another sheet. When I use a sum formula in the sheet summary field it is returning a no match. I'm assuming the sheet summary fields are limited to actual values but figured I would ask.
-
From specific cell end of the sheet
Hi, I have a project template in which I would like to use a formula that allows me to search in a range that starts at a specific cell but ends at the last line of the sheet. In some sheets I have 100 rows and in some sheets I have 500 rows so I can't put, for example, [Actual Material Costs]2:[Actual Material Costs]500…
-
SUMIF with FIND
Greetings, =SUMIFS({Commercial MRR}, {Commercial Service Type}, "10M", {Commercial Services}, FIND("soho", LOWER({Commercial Services}) > 0)) I tried the above formula that I found the logic in a post from mid 2019, but I wasn't sure if that thread was considered dead so I created this thread. I'm getting an error with the…
-
Count file names only
I'm trying to create a unique ID for documents. I would like to generate a unique number for each Category (in "Abv") but I'm struggling to not count the parent rows. My current formula is: =SUM(COUNTIFS(Auto:Auto, <Auto@row, Abr:Abr, Abr@row) + COUNTIFS(Auto:Auto, Auto@row, Abr:Abr, Abr@row)) The formula abode had been in…
-
Countifs - 2 field ranges plus a date
Hi, I am trying to create a formula to count companies (1st column) that we won a project(2nd shows win/lose) in certain date ranges (example Q1 - January to April of 2020) I can get the count formula right that counts companies that we won the project with, can't figure out how to narrow it down with the date added into…