Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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))
This is what I was looking for!
Thank you very much!
Happy to help.
Hello, We have several automations configured to copy a row to another sheet when specific criteria are met. Recently, these automations have been intermittently failing. For example, they worked this morning but stopped working this afternoon, and then they often begin working again the following day without any changes…
I have team member specific, multi project sheet, prefiltered Reports built out and I want to have these reports automatically emailed to the team member and myself every Monday morning before I'm in the office. The reports run off of the "Last 7 days" filtered for tasks accomplished. So having them automated to run and…
I'm trying to create a formula in sheet #1 that: Looks up all rows containing a certain email address in sheet #2 References a certain value in those rows (the values in question are themselves average formulas) Takes the average of all those specific values Displays that average back in sheet #1 I know there are formulas…
