-
Help with COUNTIFS formula
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
-
Stuck on a formula for a multi-drop down
Hi everyone, I'm using sheet summary to count various formulas for me and I'm stuck on the below. I need to count all rows that have "Strategy" in the Channel column, whether it's the only entry or one of several. I've tried variations using HAS or CONTAINS but it still doesn't work. =COUNTIFS(Archived:Archived,…
-
Formula returning 'Invalid Operation'
Hello, I'm having trouble with my formula and can't quite figure out how to fix it. =IF(AND([LookUp Value]10 = "Y", {April THD Tech on Call WK1} = 1), JOIN(COLLECT({April THD Tech on Call Name}, {April THD Tech on Call WK1 TOC}, HAS(@cell, [LookUp Value]2)))) Anything obvious that I am missing?
-
Cross Sheet Input Numbers
I need to imput numbers from a different sheet using =Count for each line. If someone has a better structure idea this could be put into that would be appreciated. The issue I having to report numbers per month on the smartsheet using only cross sheet referencing. What i have come up with so far is =Countif({C Type},…
-
Autofill Cells When New Rows Added
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…
-
Can the auto-numbering function be set up to utilize new numbering prefix at start of each year?
I created a sheet that uses auto-numbering to assign a number to all submitted forms. I want the numbering to utilize a prefix denoting the year and start over at 0 each year. For example the numbering of the submissions in year 2021 will start with 2021-01 continuing with 2021-02, 2021-03, etc. When the year 2022 is…
-
Complex IF OR Statement
Hi Can someone help me put these three statements together, I cant work it out. =IF([Charger/ Socket kW]@row = 300, [Formal Application Capacity (kVA)]@row / 300, [Formal Application Capacity (kVA)]@row) =IF([Charger/ Socket kW]@row = 50, [Formal Application Capacity (kVA)]@row / 50, [Formal Application Capacity…
-
Multiple email contacts in the IF statement
Hi, I have custom contact list column, which displays email contacts based on the conditions. Here's an example of that column: =IF(AND([Column1]@row = "Value1", OR([Column2]@row = "Value2", [Column2]@row = "Value3")), "email@email.com, email2@email.com, email3@email.com", IF(AND([Column1]@row = "Value5", OR([Column2]@row…
-
Recorded Date recording incorrect date
Hi Guys We are picking up an issue with a Recorded dated Ownership of the sheet was moved to another, and the dates were suddenly reporting the day before - they checked Time Zone and corrected that from US to Perth AUS - and did another test but the date is recording as the day before - in today's case it recording…
-
For dashboard purposes- differentiation to lines with a planned date to lines with no planned date
Hi all, I am looking for a bit of help with providing mitigation to my client for both servicing and remedials. This is within the facilities management sector for many retail buildings. so I have both my servicing which is drived by IF formulas and my remedial section too drived by IF formulas. I have plenty of workflows…