IF Formula help

Mital Patel

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!

Bassam Khalil

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 Khalil

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), "")

Mital Patel

@Bassam Khalil Thank you so much. It worked. I appreciate it.

Bassam Khalil

@Mital Patel 

You are welcome and I will be happy to help you any time.

Mital Patel

@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!

Bassam Khalil

@Mital Patel

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 )

Andrée Starå

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!

Mital Patel

@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!

Andrée Starå

@Mital Patel

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?

Mital Patel

@Bassam Khalil

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!

Mital Patel

@Andrée Starå Thank you so much, but that formula is not working the way I need it. I appreciate your support though. Thanks!