WEEKNUMBER from two columns

11/27/18 Edited 12/09/19

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


  • This is what I was looking for! 

    Thank you very much!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. yes


Sign In or Register to comment.