Getting formula of another cell in target cell
=FormulaText(Reference) will do the trick Documentation
formulas
Timezone conversion in a Google spreadsheet
Short answer There is no built-in function but you could build a custom function. Example /** * Converts a datetime string to a datetime string in a targe timezone. * *@param {“October 29, 2016 1:00 PM CDT”} datetimeString Date, time and timezone. *@param {“Timezone”} timeZone Target timezone *@param {“YYYY-MM-dd hh:mm a z”} Datetime format *@customfunction … Read more
Google SpreadSheet Query: Can I remove column header?
Try this: =QUERY(H4:L35,”select sum(L) where H=’First Week’ label sum(L) ””)