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
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 287 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!