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
Gelöst! Gehe zur Lösung
Gelöst von RDAOU. Gehe zur Lösung
Gelöst von RDAOU. Gehe zur Lösung
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.
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
@Anonymous
Considering that the Parameter Current Revision Date is a text parameter you can do what you requested in question 2 by using
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
Thank you it seem like you made a dynamo script
is i posible you would share it so i can look in to it
@Anonymous
Attached is the Dyn file. It uses the basic Dynamo nodes so you shouldnt need any packages
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
Hey thank you i will work on the dynamo to make it turn all other that the current revision date off as well
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.