↙️

Turn Text into Values

Master Tag
Tips & Tricks
Created
Dec 12, 2019 11:14 PM
Usage
True
And
Multiply
Format
Select
Web Tags
Function
Formula
Alternatives
Cover
↙️
(prop("Day of Week") == "Monday") ? format(13) : ""
Example
↙️
if(prop("Day of Week") == "Monday", 13, if(prop("Day of Week") == "Tuesday", 12, if(prop("Day of Week") == "Wednesday", 12, if(prop("Day of Week") == "Thursday", 10, if(prop("Day of Week") == "Friday", 12, if(prop("Day of Week") == "Saturday", 15, if(prop("Day of Week") == "Sunday", 16, 0)))))))
Example
↙️
if(prop("Day of Week") == "Monday" and prop("Clocked in") == true, 13, if(prop("Day of Week") == "Tuesday" and prop("Clocked in") == true, 12, if(prop("Day of Week") == "Wednesday" and prop("Clocked in") == true, 12, if(prop("Day of Week") == "Thursday" and prop("Clocked in") == true, 10, if(prop("Day of Week") == "Friday" and prop("Clocked in") == true, 12, if(prop("Day of Week") == "Saturday" and prop("Clocked in") == true, 15, if(prop("Day of Week") == "Sunday" and prop("Clocked in") == true, 16, 0)))))))
Example
↙️
if(prop("Shift Type") == "Day", 10.50 * prop("Hours"), if(prop("Shift Type") == "Night", 11.00 * prop("Hours"), 0))
Example