We are trying to use a nested IF formula to use two different sets of criteria to return two different results. I feel we are close because we get an Incorrect Argument error, rather than the dreaded Unparsable, but I am not seeing what we are missing. We also tried adding a "" as a return if False value but that didn't have any impact.
=IF(Status@row, OR(@cell = "Active", @cell = "Pre-Go Live", @cell = "Closing", @cell = "Pipeline - Active"), "Active", IF(Status@row, OR(@cell = "Pipeline - 0 thru 2", @cell = "Pipeline - 3. Finalist", @cell = "Pipeline - 4. Partner of Choice", @cell = "Pipeline - 5. Selected"), "Forecast"))
We want to use this as a column formula in a Capacity Status column to show a project as Active or Forecast based on what is listed in our Status column. The Status column is a single select column so we shouldn't need HAS(@cell. Do we need to check our column properties too? Thank you!
