-
Combining an IF(OR statement with an IF statement
I am using the current formula =IF(OR([Integration]@row = "-", [Integration]@row = "N/A"), "No", "Yes"). Because there is now an option to put in TBD, that needs to be noted as TBD and not just simply "no" or "yes". How can I combine the above formula with one that also says, "If it is TBD, then it should read TBD? Thanks…
-
Sumifs?
Hi, From another smartsheet I am trying to pull the total % of time spent by individual project managers on various projects that are in progress. I thought it would be a sumifs formula but it's giving me an answer of "0" instead of the percentage. Below, I have it first pulling the % column, then the Project Manager…
-
Summing Sheet summaries into one sheet
I have multiple sheets, each with the same summary items that are derived by formulas that use data in the sheet. I need to create a one row sheet that sums all the of the same summary items from each sheet so that I can use the charting function to show a donut chart based on the summed values for a portfolio dashboard.…
-
How to use COUNTIFS with two criteria? One is a date range.
Hello All, I am working on gathers metrics for my team and need help figuring out how to use COUNTIFS with the following criteria: Check box is marked as complete The date is between 01/01/20 and 12/31/20 This will be an annual request, so the date will change year over year, but want to determine what my root formula will…
-
Formulas working for some columns but not others after update
Good Morning, It seems after the update I've been having issues with a formula on my project intake sheet/meta data sheet. I'm getting a #No Match error. Certain columns are connecting appropriately but others no longer are and I can't seem to identify why? See formula below Below is the intake sheet being referenced with…
-
'=date' Formula NOT Working
Hi everyone, I tried using the =date formula on a bigger formula and I have been running into the same problem and would like some help. I first tried =date(year(1@row),month(1@row),day(1@row)) and I got #INVALID COLUMN VALUE (column type of 1@row is date). It works on excel so I tried =date(2022,12,12) and I still got…
-
IF/OR/CONTAINS
Hello! I need some help with a formula that is currently yielding #INCORRECT ARGUMENT SET. The current formula in B2 is to check the box if the Sprint column contains Flux Staging Area, STAGING AREA, STAR BLAZERS INTAKE, Bulk Status or Parking Lot. What I have entered now is =IF(OR(CONTAINS("Flux Staging Area", Sprint@row,…
-
Nested If formula for RYG
Good morning, I'm having an issue with the following formula. The red and green come out, but the yellow comes back blank. Any assistance would be appreciated. =IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row <= 0.07 - 1, "Yellow", IF([% Complete]@row = 1, "Green")))
-
Any way to have a formula automatically change input when a set of new rows added?
Hi, trying to automate a process whereby the change from week to week on a project is reflected in a graphic on a dashboard. Right now, I have the source sheet for the data copy the rows to a separate sheet once a week. I want a formula to simply find the difference between last update and the new one. This is what will be…
-
How to separate multi select values and collect distinct values?
Each period (P1,P2,P3 etc) we collect KPIs for our projects. In some new KPIs we have been asked to collect the answers involve multi select drop downs. What we would like to be able to do is to each period have a list of only the unique values. I have tried using a formula which uses JOIN, DISTINCT and COLLECT and it…
