WEEKNUMBER from two columns

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.

 

Tags:

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

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

    thinkspi.com

  • This is what I was looking for! 

    Thank you very much!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. yes

    thinkspi.com