Search text based upon date

PJay128 · 2019-04-05 02:29:51

Hi Im struggle to put together a (what should be simple) statement to search a column (section) based on the month it was checked. From the attached table i want to pull the data out of the sheet into another and record that the check has been completed for each month. So the output would be in march electrical repairs,…

Options

Comments

Paul Newcome ✭✭✭✭✭✭

04/08/19
Options
Yes. It was a closing parenthesis. Glad we got it working for you.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Trending in Smartsheet Basics

Can I change the font color of the Sheet Name in a report?
Hi all, I am trying to change the font color of the Sheet Name in a report. Scenario: I have a dashboard which contains a report showing the Sheet Name as links which is what I want. I have also color formatted the rows from the data source sheets based on criteria (i.e., a project is a dark purple fill w/white font; a…
Filter for comparing dates
Trying to create a filter to only display rows when dates in "Max Obtained Date (LW)" column are greater than dates in "Max License Status Date (NMLS) column. Any ideas?
Read cell with comma as a number/value
Dear all, I have a column with numbers that can contain a comma. I need to do a sumif on this column, but Smartsheet reads this column as text, and therefore my formular does not work. I have tried different ways to convert the column to a number in another column, but I have not managed to find a function that works. I…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Search text based upon date

Comments

Categories