nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

WEEKNUMBER from two columns

Krzysztof

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.

Find more posts tagged with

Formulas

Comments

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

Krzysztof

This is what I was looking for!

Thank you very much!

Paul Newcome

Happy to help.

Sign in to join the conversation!

Quick Links

Trending discussions

Formula to bring in a free text column
Hello, I have a data tracker that has a column with different company names. It is a free text column from a form. In my calculation sheet, I need a formula to pull in those company names from the data tracker. Is it an Index or VLookup formula? Thanks in advance.
Detect Duplicate Form Entries
Hi, I have a SS Form to capture my team's attendance on a daily basis, specifically the dates, leave type. I am capturing the employee's name using the Contacts type field in the form. Now, on the form, when I make an entry for a specific name, dates and leave type, is there an option to detect if the same entry was…
Expense columns are not syncing
The formula has been corrupted and all we have are 0's. They are in our PO Expenses but not syncing with the job.