If formula - with multiple criteria

Options
NicoleB
NicoleB ✭✭
edited 11/08/22 in Formulas and Functions

Trying to set up so that a column will return a field based on two other columns -


=IF([IND INT Stage ]:[IND INT Stage ] = "Not

Started", “IDD Not Started”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "IDD Started", @cell = "as

- is documentation completed"), “Requirements Pending”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "design/build in progress",

@cell = "joint sessions in progress", @cell = "analysis in

progress", @cell = "QS hand off in progress", @cell = "idd

signed off"), “Design/Build In Progress”, If([IND INT Stage]:[IND INT Stage} = "Hand off to QS Complete" AND [Integration Rework Status]:[Integration Rework Status], "in testing", "In Testing")


The above formula gives #unparseable error


I tried this one as well and got a different error - #Invalid Operation


=IF([IND INT Stage ]@row = "not started", "IDD Not Started", IF([IND INT Stage ]@row = OR( "IDD Started", "As - Is Documentation Completed"), "Requirements Pending", IF([IND INT Stage ]@row = OR("design/build in progress", "joint sessions in progress", "analysis in progress", "QS hand off in progress", "IDD Signed Off"), "Design/Build In progress", IF([IND INT Stage ]@row = "Hand off to QS Complete", "In Testing"))))


I also tried this formula - the error is unparseable

=IF([IND INT Stage ]:[IND INT Stage ] = "Not

Started", “IDD Not Started”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "IDD Started", @cell = "as

- is documentation completed"), “Requirements Pending”, if([IND INT Stage ]:[IND INT Stage ] = OR(@cell = "design/build in progress",

@cell = "joint sessions in progress", @cell = "analysis in

progress", @cell = "QS hand off in progress", @cell = "idd

signed off"), “Design/Build In Progress”, if([IND INT Stage ]:[IND INT Stage ] = "Hand off

to QS Complete", "In Testing"))))


 AND - Invalid operation below as well

=IF([IND INT Stage ]@row = "not started", "IDD Not

Started", IF([IND INT Stage ]@row = OR(@cell = "IDD Started", @cell = "As

- Is Documentation Completed"), "Requirements Pending", IF([IND INT Stage ]@row = OR(@cell = "design/build in progress",

@cell = "joint sessions in progress", @cell = "analysis in

progress", @cell = "QS hand off in progress", "IDD Signed

Off"), "Design/Build In progress", IF([IND INT Stage ]@row = "Hand off to QS Complete", "In

Testing"))))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!