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,…

Comments

Paul Newcome ✭✭✭✭✭✭

04/08/19

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

Alert Someone 1 Week Before Due Date
Hello Smartsheets Community, I'm sure this is a dumb question, but I can't figure it out and need some help. I need to create an alert 1 week before dates that are entered in a date column field on my sheet (example below). I tried creating an automation, but I don't see where I can select # of days prior to a date. Any…
CAPTCHA within a Form
When I turn on CAPTCHA within the Form setting, what should I see. I was thinking that with this ON, a user accessing the Form would start seeing CAPTCHA type windows and questions, however, I do not see that happening. What am I missing?
Workflow Subscription
Hello, I have someone who unsubscribed from the automation workflow notification and now needs to be added back. How can this be done? Thanks!

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

Watch video

Search text based upon date

Comments

Categories