-
Formula to auto pupulate status column based on dates
Hello, I am trying to get the status column to populate based on date range. I have a Start and Finish date in each row and want it to do the following When Start date is < today, say "NOT STARTED" When Finish date is > today, say "COMPLETE" This third one is tricky - When Start date is < = today AND Finish date is > =…
-
Formula based off a selection
Hi All, Could really use some help on trying to figure out a possible formula for the below: There will be two options for freight provided, "COMPANY, and "eShipping". When "COMPANY" is selected the true cost will populate in our total cost column. When eShipping is selected I want cost *.10 to calculate in my total cost…
-
Conditional Formatting countdown that avoids Weekend Dates
Hi all! Long story short - I have design jobs coming into rows that have a Sales Respond Date (to a customer) with customizable turnaround days for edits that then gives the designer a due date to complete the edits of a design (Next Update to Client). We use conditional formatting in the designer name column to show a…
-
If Contains Specific Year Formula
Hi, I'm trying to use a formula that will look at a date column to populate another column. If year in that date column is 2022 I want the new column to say Not applicable, but my formula is not working. =IF(CONTAINS(YEAR(2022), [First Receive]@row), "Not Applicable", "") but it's giving me an invalid data type error
-
Extracting part of a cell to return in another cell
I'm trying to come up with a formula which will take the website URL in one cell, extract what's called the root domain (website.com) without www. or https:// or any url string after the .com Here's a couple of examples of the value I have in the cell and what I would like it to return in a horizontal cell:…
-
How do I concatenate contact names from different sheets?
How do I add a contact name from a sheet to a cell in another sheet that has already other names? For instance in sheet 1, column 1, I have Person One and in column 2, I have Person Two and Person Three. How do I add the 3 names to another sheet in one cell? Thanks!
-
COUNTIFS+CONTAINS
I get the message UNPARASABLE, what am I doing wrong? I want to count the non blank fields in rage 1, when in range 4 I have a certain value AND is the range 7 = OPEN value. =COUNTIFS({Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 1};<>"";[{Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 4};…
-
Strange Formula Behavior
Greetings, I am developing a solution that automatically captures a 24-hour time (as an integer value) from the generated system date/time. The goal is to allow users to use a form on a tablet to enter a few fields of information into three sheets. My solution converts the times in each sheet correctly: Above is a portion…
-
Setting up a trigger comparing today's entry with the last entry.
Operators will enter Paint Code, Line Speed and the Date is created at the time of entry. There are MANY paint codes. How do I create a formula or workflow or BOTH to notify a manager WHEN the paint code has a lower line speed than the last time it was entered? Example below.
-
Trouble with long, nested formula...
Trying to have a column show status of requests, and have been having issues for days. IF [Provisional Requested Amount] is under 50000 and [COL Leader Approval] is Provisional Approval = Provisional Approval IF [Final Requested Amount] request is under 50000 and [COL Leader Approval] is Final Approval = Final Approval If…