IF Formula help
Hello,
I am looking to add a conditional if formula but not sure how to move forward and unsure if smartsheet has a capability.
Is it possible to check a column based on 3 other columns if not blank. and if so what do I have to write for the condition of columns not being blank. I got as far as selecting rows but unsure what to write next.
Please help. I appreciate your support.
Thanks!
Best Answer
-
Hi @Mital Patel
Hope you are fine, please try the following formula and convert it to a column format formula:
=IFERROR(IF(COUNTM([C1]@row:[C3]@row) = 3, 1), "")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Mital Patel
Hope you are fine, please try the following formula and convert it to a column format formula:
=IFERROR(IF(COUNTM([C1]@row:[C3]@row) = 3, 1), "")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
@Bassam Khalil Thank you so much. It worked. I appreciate it.
-
You are welcome and I will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
@Bassam Khalil Thank you!. So the formula worked, but I need little more help about it. What if I only want to check the column based on the other 3 column but only containing dates and don't want to count for checks if doesn't have date. Is that possible? Not sure if it makes sense.
Thanks!
-
Could you please add a sample show what exactly you need the formula to do ( if you can share a sample of your sheet with sample data cover all option you need )
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Mital Patel
I hope you're well and safe!
Try something like this. (update the column names to match yours)
=IF(COUNTIF(A@row:C@row, ISDATE(@cell)) = 3, 1)
Did that work/help?
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.
-
@Bassam Khalil Thanks.
Basically, I am trying to send a triggered email on a daily basis to my sales team about the status of the Certificate of Analysis for their products. We manufacture dietary supplement and the product has to go through various testing phase. and every phase has different due date depending on the received date and duration of the test.
My ultimate goal is to send an email with the due date when the document will be ready but not sure how to generate that so I decided to have a column for checks which is my trigger helper to automate alert email.
Hope this makes sense.
Thanks!
-
Try this instead.
=IF(COUNTIFS([Micro Due Date]@row, ISDATE(@cell), [Metals Due Date]@row, ISDATE(@cell), [Label Claim Due Date]@row, ISDATE(@cell)), 1)
Did that work?
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.
-
So for example in the image, you can see 5 dates. I am looking to send an email to my sales team about the CoA status helper date which depends on the micro due date, or metals due date or label claim due date (whichever is the latest + add 1 more business day).
I hope this makes sense.
Thanks!
-
@Andrée Starå Thank you so much, but that formula is not working the way I need it. I appreciate your support though. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!