Reply to thread

Message

<blockquote data-quote="Vee711" data-source="post: 740121">I am completely new to this and am trying to create a Register in Sharepoint.Basically what I want to do is:<ul>
<li data-xf-list-type="ul">If the date in Column 1 is coming up in the next 5 days, I want to change the font to orange</li>
<li data-xf-list-type="ul">If the date in Column 1 is overdue, I want to change the font to red</li>
<li data-xf-list-type="ul">If the date in Column 2 is not empty, do not format Column 1 (basically, remove the formatting in Column 1 once Column 2 is filled).</li>
</ul>Context: Column 2 is the date the action in Column 1 is completed.I tried using Co-Pilot to help me with JSON and it came up with the following but it doesn&#039;t seem to work:[CODE]&nbsp; &nbsp; {&nbsp; &quot;$schema&quot;: &quot;https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json&quot;,&nbsp; &quot;elmType&quot;: &quot;div&quot;,&nbsp; &quot;txtContent&quot;: &quot;@currentField&quot;,&nbsp; &quot;style&quot;: {&nbsp; &nbsp; &quot;color&quot;: &quot;=if([$COLUMN2] != &#039;&#039;, &#039;&#039;, if(@currentField &lt;= @now, &#039;red&#039;, if(@currentField &lt;= @now + 2592000000 &amp;&amp; @currentField &gt; @now, &#039;orange&#039;, &#039;green&#039;)))&quot;&nbsp; }}[/CODE]Can I please get some guidance?Thanks!</blockquote>

[QUOTE="Vee711, post: 740121"] I am completely new to this and am trying to create a Register in Sharepoint. Basically what I want to do is: [LIST] [*]If the date in Column 1 is coming up in the next 5 days, I want to change the font to orange [*]If the date in Column 1 is overdue, I want to change the font to red [*]If the date in Column 2 is not empty, do not format Column 1 (basically, remove the formatting in Column 1 once Column 2 is filled). [/LIST] Context: Column 2 is the date the action in Column 1 is completed. I tried using Co-Pilot to help me with JSON and it came up with the following but it doesn't seem to work: [CODE] { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if([$COLUMN2] != '', '', if(@currentField <= @now, 'red', if(@currentField <= @now + 2592000000 && @currentField > @now, 'orange', 'green')))" } } [/CODE] Can I please get some guidance? Thanks! [/QUOTE]

Name

Verification