is there a way to enter a number that shows up as a text?
for ex, evter in a column "1" and it generates a job title. also, can i combine that with multiple jobs in each cell??
Answers
-
To enter a number as text, Try this " '1 "
and I don't understand the rest of the question.
-
Hi nctd,
Yes. there is fairly simple way to accomplish that with automation. Click on Automation on the top left corner of the screen. In the dropdown menu click "Create a workflow from scratch."
In the Trigger part, change Any Field to the column where you want to enter the numbers.
Change Add a Value to 1 (or 2 or 3).
In the Select an action part, click on Change cell Value.
Select the column where you want the jobtitle to go. (Can be the same as the number column.)
Enter the new value, e.g. CEO or dishwasher.
Repeat for all numbers.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!