Formula Help

Kpetruc

I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type] is On Demand, Post, or Web the value should show N/A but IF the [Kit Type] is Pre -5 days from [Kit In-Hand (Pre or ANOC)] to get the date needed OR IF the [Kit Type]
is ANOC -5 days from [Kit In-Hand (Pre or ANOC)] to get the date needed. The bold part works but once i change the Kit type to Pre or ANOC for example i get an error message #invalid operations. Any insight?

Kelly Moore

Hey @Kpetruc

Try this. I assumed that your [Kit In-Hand (Pre or ANOC)] column was already registering the correct date.

=IF(OR(AND([Kit Type]@row = "Pre -5 days", ISDATE([Kit In-Hand (Pre or ANOC)]@row)), AND([Kit Type]@row = "ANOC -5 days", ISDATE([Kit In-Hand (Pre or ANOC)]@row))), [Kit In-Hand (Pre or ANOC)]@row, IF(OR([Kit Type]@row = "On Demand", [Kit Type]@row = "Post", [Kit Type]@row = "Web"), "NA"))

Does this work for you?

Kelly

Kelly Moore

Hey @Kpetruc

Try this. I assumed that your [Kit In-Hand (Pre or ANOC)] column was already registering the correct date.

=IF(OR(AND([Kit Type]@row = "Pre -5 days", ISDATE([Kit In-Hand (Pre or ANOC)]@row)), AND([Kit Type]@row = "ANOC -5 days", ISDATE([Kit In-Hand (Pre or ANOC)]@row))), [Kit In-Hand (Pre or ANOC)]@row, IF(OR([Kit Type]@row = "On Demand", [Kit Type]@row = "Post", [Kit Type]@row = "Web"), "NA"))

Does this work for you?

Kelly

Kpetruc

I did not have the in hand column in a date form I missed that. Thank you so much