-
Converting Multiple IF function instances to column formula
Hi, I am trying to set up time sheet for employees where formula in the column will calculate their income for hours worked. Employees are using form to enter their hours. I have set up their individual hourly rates in the summary sheet. "Amount Earned" Column contains formula. Formula is: =IF(Name1 = "Worker1",[Work…
-
Row Delimiter in a formula?
Hi all, I have a sheet that contains hierarchy, I needed to make a dynamic view and maintain the hierarchy, which I partially achieved with formula columns. Long story short, I have a parent cell (program) and children cells (parts). In dynamic view I want to have 'program' in the main view, which I achieved and 'parts' in…
-
Convert text to date
Hi I have a column containing text, which contains a date in MM/DD/YY format, followed by a longer string of text. For example, one of the cells contains "07/26/22-G" I want to populate another column, with column type = date, with the date, so that I can order by date. I tried this using this formula =MID([Test1]@row, 1,…
-
Placeholder in automated email of sheet name?
I would like to be able to include the sheet name in a time based update automation which is a part of a template set. While we could make it a part of the set up process to update this automation manually with each new project, ideally we could just insert a placeholder for {{Sheet Name}} and have it fill in. This would…
-
Reference sheet name in formula.
It would be nice to be able to put something such as @sheetname or {{Sheet Name}} or something to call specifically to the sheet name for a formula. This would make it easy for sheets to be duplicated across vendors/products without having to change anything but the name of the sheet itself.
-
Populate the Day of the week using a calendar date
Is there a magic formula I can use to populate the day of the week (Mon, Tue, Wed, Etc...) given the calendar date in another field? Ex: Calendar Date Day of Week 08/18/2021 Wed 08/19/2021 Thu Thanks!
-
formula to return what day of the week a date is?
in Excel this would be the formula =CHOOSE(WEEKDAY(A1),"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat") Does not work in SS?
-
Summary Formula
I'm trying to get a formula set up in the sheet summary to get rows added within the last 90 days, and then a vlookup to get a cell value. I've tried numerous formulas but they're all coming up with an error =IF(TODAY() - Created:Created <= 90, VLOOKUP("Reviewer", [Peer / Reviewer Rating]:Trust, 10, false),) any ideas…
-
Creating Periodic based off date stamp
Since the option to record a date in a work flow can not be added in before copying rows action there is a work around. First record a date when a date is reached, set to the conditions within the periodic. Finish by record a date, do not assign in this work flow or copy to a data base that is automated to distribute the…
-
Sheet Picker Update for Move/Copy Row Automations is now generally available
Hi Community, We updated the sheet picker UI used to specify the destination sheet for move and copy row automated workflows. The new sheet picker UI is faster and more consistent with other areas of the product, like Search and Reports. Licensed users on all Commercial US and Commercial EU plans will have access to the…