# Hello, i am trying to create an If-Then-Else formula to calculate Qty of Doors we can manufacture?

Options
✭✭

Based on 'Qty of Doors' times by 3 Types (N/A = 1, D = 1.25 and F = 1.5), divided by the 'Team Size', divided by 'Throughput Target'.

## Answers

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭
Options

Please see image attached. Hope this helps.

'Production Days' = 'Qty of Timber Doors' x ' DTM/FDM' / 'Team Size' / 'Throughput Target'

• Options

I am trying to complete a similar calculation for level of effort. For this exercise I am using Small Effort. If status is a certain value, then if size is small, medium, or large a value is returned. Specifically,

IF Stage/Status = "03 - Technical"

OR Stage/Status = "04 - Waiting"

OR Stage/Status = "05 - Development"

OR Stage/Status = "06 - Testing"

THEN

IF T-Shirt Size = "Small"

THEN Small Effort is 1

ELSE

IF T-Shirt Size = "Medium"

THEN Small Effort is 5

ELSE

IF T-Shirt Size = "Large"

THEN Small Effort is 10

ELSE

Small Effort = 0

Sample data and expected results

I have successfully created the criteria for T-Shirt Size values using

=IF([T-Shirt Size]@row = "Small", 1, IF([T-Shirt Size]@row = "Medium", 5, IF([T-Shirt Size]@row = "Large", 10, "")))

I am struggling with how to incorporate the condition of stage/status. Any help would be appreciated.

Best Regards,

Jean McAllister

• edited 04/28/23
Options

Figured it out! I had a special character in my formula. Although I had more conditions than originally asked the following trim formula netted the desired results:

=IF(OR([Stage/Status]@row = "03 - Technical Design & Review", [Stage/Status]@row = "04 - Waiting for Development", [Stage/Status]@row = "05 - In Development"), IF([T-Shirt Size]@row = "Small", 1,IF([T-Shirt Size]@row = "Medium", 5, IF([T-Shirt Size]@row = "Large", 10, 0))))

Final Formula in case I missed some commas, parens, or anything else that gives a parsing error.

=IF(OR([Stage/Status]@row = "00 - Triage",[Stage/Status]@row = "02 - Functional Spec", [Stage/Status]@row = "03 - Technical Design & Review", [Stage/Status]@row = "04 - Waiting for Development", [Stage/Status]@row = "05 - In Development",[Stage/Status]@row = "06 - Testing Cycle",[Stage/Status]@row = "07 - Staging",[Stage/Status]@row = "08 - Ready for Deployment",[Stage/Status]@row = "09 - Closed"), IF([T-Shirt Size]@row = "X-Small", 1, IF([T-Shirt Size]@row = "Small", 5, IF([T-Shirt Size]@row = "Medium", 20, IF([T-Shirt Size]@row = "Large", 40, IF([T-Shirt Size]@row = "X-Large", 70, 0))))))

Best Regards,

Jean McAllister

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!