Display a date from one column into a text column of another
I have a sheet that I have one column that is a date column. I need that date to be populated into another column cell that is text format. How can I accomplish this? Currently When a date is inputted the corresponding column show the following.
The formula used is this.
Any help would be appreciated.
Best Answer
-
Try this:
=INDEX([PS-Meta]:[PS-Meta], 1) + ""
Answers
-
Hi
You can try the below formula:
=[PS-Meta]@row + ""
Thank you!
-
Thanks but the result is a blank cell.
-
It worked for me. Can you make sure there is a date in your "PS-Meta" column?
-
You just need to "add double quotes" to whatever you are currently using for your cell reference. If the cell you are referencing is in a different row from the cell you are wanting to contain this text version of a date, you would replace the "@row" portion with the appropriate row number.
=Column Name]@row + ""
=[Column Name]1 + ""
-
Thanks Paul, that almost gets me there. So the information is populated into the sheet by a form. When the form adds a row at the top the formula now changes to =[PS-Meta]2 + "". The date added to the new first row will be the only date in the entire column. I tried just =[PS-Meta] + "" but that comes back as unparseable.
Thoughts?
-
Try this:
=INDEX([PS-Meta]:[PS-Meta], 1) + ""
-
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
