How to Convert Dropdown text into number of days

Javid

How do I calculate & convert dropdown text (Daily, Weekly, Monthly....) where Day = 1, Week = 7..... into number of days so it can be calculated into my sheet's 'Recurrence' filed (Re attached)

Sameer Karkhanis

There is no label value concept in the dropdown so you cannot do that in the same column (Reference), however if you want to populate the next submission date column then you can use the IF formula and add days based on Recurrence value; something like,

IF(Recurrence@row = "Daily", Recurrence@row + 1, IF(Recurrence@row = "Weekly", Recurrence@row + 7, Recurrence@row + 30))

Sameer Karkhanis

There is no label value concept in the dropdown so you cannot do that in the same column (Reference), however if you want to populate the next submission date column then you can use the IF formula and add days based on Recurrence value; something like,

IF(Recurrence@row = "Daily", Recurrence@row + 1, IF(Recurrence@row = "Weekly", Recurrence@row + 7, Recurrence@row + 30))

Javid

Thanks Sameer! that works like a charm :)