↙️

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
Day of Week
Name
Hours
Pay
↙️
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
Day of Week
Worker
Hours
Pay
Monday
Thursday
Tuesday
↙️
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
Day of Week
Name
Clocked in
Hours
Pay
Monday
Clocked in
Thursday
Clocked in
Tuesday
Clocked in
↙️
if(prop("Shift Type") == "Day", 10.50 * prop("Hours"), if(prop("Shift Type") == "Night", 11.00 * prop("Hours"), 0))
Example
Day of Week
Shift Type
Name
Clocked in
Hours
Pay
Monday
Day
Clocked in
Monday
Day
Clocked in
Monday
Night
Clocked in
Thursday
Night
Clocked in
Thursday
Day
Clocked in
Tuesday
Day
Clocked in
Tuesday
Night
Clocked in
Tuesday
Day
Clocked in