Welcome!

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.

Formulas

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!

Happy to help.

Weighted Average
how to get the formula to get the weighted average of the scrap
Date Logic for Requests Created After Business Hours
I want to set up Smartsheet so that if a request is submitted on the same day and the submission time is between 6:00 PM and 12:00 AM, the Request Submitted Date should automatically move to the next day. For all other cases, it should remain the same day.
can I get automated reminders for a 30 day check in when dates in my start date column are different
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.