Why do the dates change in the fillable PDF?
Hello I am making fillable PDF and I was trying to put a birthday in them and when it loaded it came out as (Not real) 04/05/23. I have changed it in the smart sheet cells where the dates read out as April 5, 2023 but when it hits the fillable PDF it changes to just numbers. I need it to be spelled out does anyone know why it changes it? If so what can i do to fix it? I thought about making helping columns but if i did i don't know what to put in them :(
Thanks,
Jeremy
Best Answer
-
I'm guessing it's a situation where the PDF generation uses the value of a cell, as opposed to it's display value which would have your formatting set. I think to get around it, you'd need to make another column that would convert the date to a string that's formatted as you'd like. Then use that new column in the PDF generation step.
I think this formula would work for you (Change [DateColumn] to match your sheet):
=IF(MONTH([DateColumn]@row) = 1, "January", IF(MONTH([DateColumn]@row) = 2, "February", IF(MONTH([DateColumn]@row) = 3, "March", IF(MONTH([DateColumn]@row) = 4, "April", IF(MONTH([DateColumn]@row) = 5, "May", IF(MONTH([DateColumn]@row) = 6, "June", IF(MONTH([DateColumn]@row) = 7, "July", IF(MONTH([DateColumn]@row) = 8, "August", IF(MONTH([DateColumn]@row) = 9, "September", IF(MONTH([DateColumn]@row) = 10, "October", IF(MONTH([DateColumn]@row) = 11, "November", IF(MONTH([DateColumn]@row) = 12, "December")))))))))))) + " " + DAY([DateColumn]@row) + ", " + YEAR([DateColumn]@row)
Answers
-
Are you filling out the sheet or are you using a form? If you are collecting through a form, you can just have the user select their Month and have them input their Day and Year.
-
I'm guessing it's a situation where the PDF generation uses the value of a cell, as opposed to it's display value which would have your formatting set. I think to get around it, you'd need to make another column that would convert the date to a string that's formatted as you'd like. Then use that new column in the PDF generation step.
I think this formula would work for you (Change [DateColumn] to match your sheet):
=IF(MONTH([DateColumn]@row) = 1, "January", IF(MONTH([DateColumn]@row) = 2, "February", IF(MONTH([DateColumn]@row) = 3, "March", IF(MONTH([DateColumn]@row) = 4, "April", IF(MONTH([DateColumn]@row) = 5, "May", IF(MONTH([DateColumn]@row) = 6, "June", IF(MONTH([DateColumn]@row) = 7, "July", IF(MONTH([DateColumn]@row) = 8, "August", IF(MONTH([DateColumn]@row) = 9, "September", IF(MONTH([DateColumn]@row) = 10, "October", IF(MONTH([DateColumn]@row) = 11, "November", IF(MONTH([DateColumn]@row) = 12, "December")))))))))))) + " " + DAY([DateColumn]@row) + ", " + YEAR([DateColumn]@row)
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives