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

Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%

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

Watch video

Search text based upon date

Comments

Categories