Hello, i am trying to create an If-Then-Else formula to calculate Qty of Doors we can manufacture?
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
-
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!
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.
-
Please see image attached. Hope this helps.
'Production Days' = 'Qty of Timber Doors' x ' DTM/FDM' / 'Team Size' / 'Throughput Target'
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!