WEEKNUMBER from two columns

edited 12/09/19 in Formulas and Functions

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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!