WEEKNUMBER from two columns

Krzysztof · 11/27/18

Hi All,

I have two columns where one column will have a DATE and the other one will be blank.

It will never happen that both columns will have a date in them.

Now I want Smartsheet to check which two cells has a Date and show WEEKNUMBER.

Paul Newcome · 11/27/18

Give this a shot. Just change the column names to whatever you are using...

=IF(ISDATE([Date Column 1]@row), WEEKNUMBER([Date Column 1]@row), WEEKNUMBER([Date Column 2]@row))

Krzysztof · 11/27/18

This is what I was looking for!

Thank you very much!

Paul Newcome · 11/27/18

Happy to help.

Comments