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.
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))
10xViz.com
This is what I was looking for!
Thank you very much!
Happy to help.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked but I need assistance on changing the order of it. Course Date with Parentheses around the date and Couse Name Formula that I have: =JOIN(" ", "(" + [Course Date]@row + ")", [Course]@row) that will not work Example what I want:…
Hi, I have several formulas in sheet summary that reference a single person in an assignment column in my sheet. The formulas are repeated multiple times and work just fine, however I seem to have issues with this single person. Any formula that includes this person, does not work. Any insight on how to fix this? I've…
I have multiple selections in a column and when I tried to use countifs, it will not pick up the label that is combinated with other options. For example, in Column B, I have following look up values - Role 1, Role 2, Role 3, etc, but some rows have two or more roles - so in one row, it will say role 1, role 3. In another…