Do I need to use Quotation marks when I like to trigger an action based on a Phrase in a cell?
Do I need to use Quotation marks when I like to trigger an action based on a Phrase in a cell?
In my template is used for testing. It contains a contact column and a column where a person should advise if something passes or fails. The pass fail cell contains a default value e.g.: Select Pass/Fail from the dropdown.
When clicking on the cell, dropdown forces the user to select Pass or Fail.
I like to send an automated reminder to the contact every two days when the initial default phrase is still in the cell.
Since the phrase is not part of the dropdown, I would use "contains" as the condition and the value is Select Pass/Fail from the dropdown. Do I need to put this phrase in quotation marks as "Select Pass/Fail from the dropdown", so that the automation is not triggered when the cell only contains the word pass or the word fail?
Thanks
SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT
PLATFORM ENGINEERING & TECHNOLOGY TEAM
AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL
M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM
follow us on twitter: @AmexGBT
follow us on instagram: @AmexGBT
Answers
-
You should not need to use quotes.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!