Gantt Chart column view wrong formula

pnp / List-Formatting

List Formatting Samples for use in SharePoint and Microsoft Lists

https://pnp.github.io/List-Formatting/

MIT License

1.7k stars 823 forks source link

Gantt Chart column view wrong formula #724

Closed MbertoldiNormal closed 8 months ago

MbertoldiNormal commented 8 months ago

column-samples/generic-gantt-chart/generic-gantt-chart.json

i have a syntax error everytime i try to add the calculated formula Screen Shot 2023-10-11 at 10 10 30 PM

But the formating in yyyy-mm-dd works just fine Screen Shot 2023-10-11 at 10 17 16 PM

Can you please tell me what i'm doing wrong ? for info im in Canada so i know that formating could be an issue sometimes

tecchan1107 commented 8 months ago

Hi @MbertoldiNormal ! Thanks for submitting the issue!

i have a syntax error everytime i try to add the calculated formula

The formula looks fine to me. What happens if you set up the following formula to try it out?

=TEXT([Start],"yyyy-MM-dd")

tecchan1107 commented 8 months ago

I found the following article. Maybe if you change "," to ";" it might work. https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)#important-notes

(I had never heard of such a specification😱)

tecchan1107 commented 8 months ago

I created a site where the default language is French and tried the formula, and when I set the delimiter to "," I got an error screen, but when I set it to ";" I had no problem!

Also, I replaced "," with ";" in the Gantt chart formula, and it works fine.

=TEXTE(Start;"yyyy-MM-dd")&"^"&TEXTE(End;"yyyy-MM-dd")&"(2023-08-01_2024-01-31)"

Please try the above formula!

MbertoldiNormal commented 8 months ago

Works perfectly Thanks !!!

one thing i could suggest is a way change the value of the gantt chart inside the menu it'll be great, instead of changing the whole formula to change the time range.

just like those for changing the start and end date