Metrics sheet - Want to use formula to pull in date when column type is "text/number"
Hello, and thanks so much for any support with functionality or a work around.
I am creating a summary page for the system I am building. I would like the summary metrics to form a grid like table for visualizing sections of data.
First column is the title and second column is the data. The column type for pulling in the data is a text column where eI am placing different formulas to pull in different information for the summary page. Some of the formulas are index/collect, some are SUMIF and COUNTIF functions. When I try to pull in the dates, I get an error message because the column is text rather than date. I do not want the entire column to be date or the text won't pull in. It seems like I can't have both pull into the grid in a clean way because of this column type issue. It would work to have a third column just for the dates, but that throws off the visual I am going for.
See screenshots for visualization.
- Both circled cells have the same formula, but different column types. Note how the date pulls in on Column 4 because it is a Date Type, but not Column 2 because it is a text/number type.
Note how the date pulls in on Column 4 because it is a Date Type
and I get an error in column 2 because it is a Text Type
Formulas are the same in each cell
Is there any way to get Column 2 to populate the date, rather than having to off-set my table?
Best Answer
-
I hope you're well and safe!
Try something like this.
Add +"" at the end of the formula in column2.
Did that work?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
I hope you're well and safe!
Try something like this.
Add +"" at the end of the formula in column2.
Did that work?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!