prop("Planned hours") - prop("Logged hours")Function name | Description | Formula example |
if | Displays a value depending on a condition. | if(10 > 5, "greater", "less") |
empty | Checks whether a value is empty. | empty("") |
and | Checks whether all conditions are true. | and(10 > 5, 3 < 7) |
or | Checks whether at least one condition is true. | or(10 > 5, 3 > 7) |
round | Rounds to the specified number of decimal places. | round(12.345, 2) |
format | Converts a value to text. | "Quantity: " + format(3) |
contains | Checks whether a phrase is included. | contains("Slashpage", "page") |
formatDate | Changes the date display format. | formatDate(prop("Due date"), "YYYY-MM-DD") |
dateAdd | Adds a period to a date. | dateAdd(prop("Due date"), 7, "days") |
dateBetween | Calculates the difference between two dates. | dateBetween(prop("마감일"), prop("시작일"), "days") |