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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 138 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!