Calulations forumals to revit revision date

[Anonymous]

hi im trying to do a yes no function in my sheet schedule to turn yes no parameter on or off 

so i made a yes no parameter to control the color of the fields in my schedule that color the field if there is a checkmark in my yes no  parameter see below

now i like to control the yes/ no parameter by af calculated function doing like this 

if(current Revision Date = 2021.10.10 my yes/no parameter is set to yes else to no 

but i seems like a cant use a specific date to control it is there any way to do this 

[Alfredo_Medina]

About the first question: the conditional format is supposed to highlight cells of a column, not rows. I don't think you can do what you are trying to do (highlight all the row).

About the second question: the yes/no needs to be a calculated value, yes/no, with a formula, based on the value of "current revision date", BUT only if "current revision date" is a number. It looks like it is text. It's not possible to use text parameters as the condition to evaluate in an IF formula.

[Anonymous]

you can set all your Conditinal format to look at the yes no parameter so thats ok 

but sad i cant control the yes no parameter to equals to a specifik data in a if statement 

thanks for the answer hopefully this i a option in the future  

[RDAOU · Accepted solution]

@Anonymous 

Considering that the Parameter Current Revision Date is a text parameter you can do what you requested in question 2 by using 

1. The Yes/No Parameter and the conditional formatting you used in Step 1 (which works fine) +
2. Few OOTB basic nodes in Dynamo to filter the revision based on the test string 2020.10.10 and accordingly set the Parameter created above to either Yes or No (Cluck the Image to play the GIF)

[Anonymous]

Thank you it seem like you made a dynamo script 

is i posible you would share it so i can look in to it 

[RDAOU · Accepted solution]

@Anonymous 

Attached is the Dyn file. It uses the basic Dynamo nodes so you shouldnt need any packages

1. Place it in the Default Dynamo Player Folder 
2. Before you run, Edit the inputs to match Date and the Override Parameter name
3. Switch on to apply Formatting or Off to Remove Formatting

[Anonymous]

Hey thank you i will work on the dynamo to make it turn all other that the current revision date off as well