Combining AND with HAS and WEEKNUMBER

Joseph Adams
Joseph Adams ✭✭✭✭
edited 11/19/21 in Formulas and Functions

Hello Again,

My goal is to have a formula that will do the following:

If the Lot ID@row is found on the {Lot ID} column on an Archive sheet


The WEEKNUMBER(Move Date) where the Lot ID on the Archive sheet was found is equal to Week#@row

THEN give me a value. If not then 0.

=IF(AND(HAS({Lot ID- Archive}, [Lot ID]@row)), WEEKNUMBER({Move Date- Archive}), [Week #]@row), some value, 0))

My formula above isnt working. I always get mixed up with AND formulas. I also think I can use the @cell function but again I am not good with that one

Any help would be appreciated



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!