Send number to another sheet. Get text

Volodymyr L

Sorry, i worked almost all day and made SHEET Formula ( pict 1) to transfer NUMBER in to a Text

It`s too late and the head doesnt work well..

I have a Column with Numbers ( pict 2 ). I want second empty column to get the number from left one - send it to another Sheet, specifil cell and get the TEXT back

How can i do that? Need to sleep.....

Volodymyr L

so, i made the formula which has the size like the whole SHEET

And i want to send to one cell the NUMBER and GET the TEXT back...

Please help! 💙💛

Genevieve P.

Hi @Volodymyr L

In this instance it may be easiest to use direct cell links. Here's a Help Article that goes through how to set this up:

https://help.smartsheet.com/learning-track/level-2-intermediate-users/cell-linking

Another option would be to create a Row Report instead of a second sheet. This would allow you to select both the number column and the text column, so they update in real-time. If you're on a Business or Enterprise plan, you can look at multiple sheets in just one Report. Then you can filter by information that would only bring in that top row from each sheet.

Here's a free webinar on Reports:

https://help.smartsheet.com/learning-track/onboarding-webinars/smartstart-reporting

Cheers,

Genevieve