Timeline for In a Sharepoint list, can I format a date column by multiplying the date with a value in another column?
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 4 at 11:29 | vote | accept | Rozemarijn Hoobroeckx | ||
| Mar 4 at 11:29 | comment | added | Rozemarijn Hoobroeckx | I tried it in a different work-environment. It worked! I switched back to my list: it worked! Both samples..... I don't know why it didn't before, but I'm glad. Thank you very much! | |
| Feb 26 at 16:59 | comment | added | Matiur Rahman | I'm not sure either. Have you tried the same in any other sites that you have access to? | |
| Feb 26 at 15:41 | comment | added | Rozemarijn Hoobroeckx | Thanks for the alternative! Sorry to say I get the same results as before: no yellow. I don't undestand why it is different in my list. | |
| Feb 25 at 16:22 | comment | added | Rozemarijn Hoobroeckx | thanks! I added information in the question, hopefully you can use that to see what happens. | |
| Feb 25 at 15:25 | history | edited | Matiur Rahman | CC BY-SA 4.0 | added 575 characters in body |
| Feb 25 at 15:10 | comment | added | Matiur Rahman | Yes, post whatever you can. I will try to use your JSON and see if it works for my test. Also, we can try another element like [style] instead of [attributes] to update back-ground color conditionally. | |
| Feb 25 at 15:07 | comment | added | Rozemarijn Hoobroeckx | Thanks. I started a new list and used your column names and data sampled. Next I used your JSON samples. The sample for [DateXYearAgo] worked. The sample for [DateColumn] did not, unfortunately. I checked the internal column names to be sure. I saved both JSON fields and refreshed. All fields stay white. (I can't add screenshots here to show what I did, shall I edit my question to add information and screenshots?) | |
| Feb 25 at 13:44 | comment | added | Matiur Rahman | You save the JSON applied to [DateColumn] and then refresh the view. Sometimes the view doesn't get refreshed automatically. Also, make sure you provide the correct internal name of the column when referring other columns in JSON. As you can see, I tested the JSON before posting it, so there must be something wrong with column names. You can try creating a new list with the same name of the columns that I've in the sample screenshot and try again | |
| Feb 25 at 13:31 | comment | added | Rozemarijn Hoobroeckx | Thank you very much for your suggestion! Unfortunately it did not yet work. I first tested your sample for DateXYearAgo, where I changed the column name. That worked like in your screenshot (even though the month is the month before now for some reason). That was promising! Next I tried the sample JSON for the date column. I can see the logic in that: if the date in the field is less than the date that "code for DateXYearAgo" produces, make the background yellow. But the fields remain white. Strange, because your screenshot proves it worked when you did it. | |
| Feb 20 at 4:11 | history | edited | Matiur Rahman | CC BY-SA 4.0 | added 605 characters in body |
| Feb 20 at 4:05 | history | answered | Matiur Rahman | CC BY-SA 4.0 |