I built a button that clones a task (=creates a copy) on the next date. I tried to use if() to build a formula to make sure that if the task was itself a clone, the new clone would be based on information from the parent task through a lookup column.
However, all buttons in the table are greyed out if there is no information in the lookup column. It seems to me as if the button evaluates both the code in both the true and false part of my if()-statement before executing, which causes an error and the button greys out.
Is this normal for If()? Or is caused by inner workings of the button?
I solved this by creating a separate button to run the formula that creates a copy of a clone.
You can find my doc here: Week planning Kanban board.