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

Jason123

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'.

Andrée Starå

Hi @Jason123

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!

Jason123

Please see image attached. Hope this helps.

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

jmcallister

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

jmcallister

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