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've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.
So I am trying to make a metric sheet that uses a COUNTIFS sorting by month, year, lane, and to only count if approve is check. I will make a dashboard that eventually sorts by the lanes (3 of them in total) and it will be tracked for trends in change in months and years. Below is the sheet that is connected to a form…
I've got a formula that flags overdue tasks, but it flags every task with no date. Is there a way to omit nulls? =IF(Status@row <> "Complete", IF(Finish@row > TODAY(), 0, 1))