-
Date Formula
Good Day. I am setting up a service schedule for equipment and would like some advise on a formula. Sheet 1 - Calendar setup which indicates "Workdays" S1-C1; S1-C2; S1-C3; S1-C4 Sheet 2: S2-C1; S2-C2; S2-C3; S2-C4; S2-C5; S2-C6; S2-C7; S2-C8; S2-C9 S2-C7 DATE = Previous service date S2-C3 Workdays = S2-C1 / S2-C2 S2-C4…
-
Restricted view in dynamic view. I want to use multiple e-mail addresses to restrict access.
I have created a reference sheet where per account the e-mail addresses are joined i.e. =JOIN(CHILDREN([Primary Column]@row); SUBSTITUTE([carriage return]@row; "-"; "")), In the Carriage return column I have a - CR-. I have multiple sheets that are using forms to receive data. Based on the entered data, the "account" field…
-
Blue ball if 100 %
I designed a sheet in which a 100 % progress (available in a dropdown menu) should be automatically turn blue in another column I tried to use an if formula but it is UNPARSEABLE =IF(Fortschritt@row = "100%" ; "Blau") What am I missing? Thx for help!
-
formula remove text /keep text in (...)
Hi Experts, I would like to keep only the text which is in brackets below. [clear onix/ftwr white/solar yellow (FY6226), orbit indigo/ftwr white/tactile blue (FY7852), ftwr white/solar red/iron met. (FY6218), core black/core black/dark grey (FY6222)] Result in the new column should be FY6226, FY7852, FY7852, FY6222 I start…
-
Calculating a due date based on date received in hours vs days
Hello! I am intaking orders from my clients. A date, with hours and minutes, automatically records when a row is entered. I would like to set up a column for a due date that uses the same date/hours/minutes display. Example: A row is entered and a date with hours and minutes is automatically recorded. An express order is…
-
Formula assistance
Hi, Could someone please help me understand why my formula doesn't work. What I am trying to achieve is: IF today's date is between the CI Start & CI Finish, then return "Consultants Inspections" IF today's date is between the BSI Start & BSI Finish, then return "Building Surveyor Inspections" IF today's date is between…
-
Universal Name Ranges
I'm looking for an option to create a universal name range that I can use across all sheets. I have created a sheet that contains the following columns Team / Office / Division I use this to translate reports that only contain Team info into Office and Division level reports by using a =VLOOKUP. However, every time I need…
-
Parent with Left & Find
I'm trying to create a column formula that will populate with the leftmost word in the Parent column. I know this formula works: =LEFT([Task Name]@row, FIND(" ", [Task Name]@row) - 1) But when I put PARENT in front, it comes back as #UNPARSEABLE =PARENT(LEFT([Task Name]@row, FIND(" ", [Task Name]@row) - 1)) What am I doing…
-
Sequential Approvals with Missing Contacts
Hi All! I'm trying to build an automation that sends out approvals in sequence. If a contact column (1-3) is blank, it should skip to the next approver so the workflow can continue. As I understand the approval automation, it will run in sequence written, but if there's no contact assigned, then the workflow won't run or…
-
Is there a way to copy the contents of a cell from one sheet to another?
I am trying to make a metadata sheet, that pulls data from multiple other sheets. I cannot use cell linking, because I use forms to capture data. The form inserts a new row into the sheet, which doesn't have the linking. I've read cross sheet formulas can accomplish this, but I can't seem to figure out how.