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))
CERTIFIED SMARTSHEET PLATINUM PARTNER
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
I have a formula that returns the number of Volunteers we have signed up IF they are assigned to any stand (it will not count them if they are assigned Waitlist or $$). My current formula that IS working is: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$") It works great. However, I…
See attached document for details, but I need to select email addresses from an external sheet where the contents of a multi-select column is used as the criteria. This was my attempt. No errors, but it doesn't return anything. =JOIN(COLLECT({Email Address}, {Dealer Name}, HAS(@cell, DEALER@row)), CHAR(10))
Hi All! Does anyone know why sometimes it shows " ' " in a cell when an excel file is imported? I´m having a hard time when it happens because VLOOKUP formula cannot find the information ... Thank you & Regards, Camila