3

You can do it similar to that in Excel :) You can checkout the below sample to get an idea: "background-color": "= if([$OtherColumn] == 'Red', 'red', if([$OtherColumn] == 'Green', 'green', if([$OtherColumn] == 'Amber', 'amber', if([$OtherColumn] == 'Gray', 'gray', 'blue'))))"


3

I could reproduce your issue on my end if the column "Score" is a single line of text column. Solution 1: change the type of column "Score" to number instead of single line of text. Solution 2: add quotes to the number 70 in your formula, like this: =IF([Score]>"70","A","F")


2

Since you will send different emails, I think you should use 7 if condition by using OOB workflow actions as below: If you don’t want to use Else, you can all if condition to "Parallel Block" as below:


2

The FIND function is not real friendly… if there is not a match it returns an error. Here's one solution: =IF( NOT(ISERR(FIND("Andrews",[Tracking Number]))), "ANDREWS", IF( NOT(ISERR(FIND("Bolling",[Tracking Number]))), "BOLLING", IF( NOT(ISERR(FIND("Pentagon",[Tracking Number]))), "PENTAGON", "none" ))) Here's an alternate solution: =IF( ...


1

You need to set the Visible property of your Paid Date field based on the value of your field Stage. To check the value of Stage is equal to "Stage 7" or not, you need to use IF function. You need to use your formula in Visible property of Paid Date field something like below: IF(Stage.Value = "Stage 7", true, false) Also, another way is to use Variable ...


1

As you are saying: "AAA" is a link not text I believe it should either be like http://AAA or https://AAA. So in that case you can use below JSON code to hide the links with http://AAA or https://AAA: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "@currentField....


Only top voted, non community-wiki answers of a minimum length are eligible