-
Formula help needed - if/then
Is there a way to make my formula (below) that if the "type of CPG" says "priority" in it that it can be - 21 days and all other types would be - 14 days? hopefully that makes sense!
-
Report totals formula
Hi, I have an example below. On my report, months remaining for each store is correct, based on inventory/sales pace per month. However, in the total, I cannot add the months remaining to get an accurate number, which the report is trying to do. (It doesn't work if any of the sales pace numbers are below 1. I need to…
-
Help with IF formula returning "invalid operation" message
I am applying this formula and get an "invalid operation" return message. Essentially, I need a function that checks if the latest or most recent date in which a member was met by Sales team is greater than 1st of Jan 2024 . In such case, it should return "Yes" and if not it should return "No". Can somebody assist with the…
-
Formula Assistance for Returning a Due Date
Hello, I feel like I'm almost there on the formula, but can't figure out why WORKDAY is causing a #unparseable error. Function of the formula: If urgent flag is marked on the row I want the due date to be due on the same date that was by the 'Date Created' column type. If the flag is not marked, I want the formula to…
-
Auto sort Rows
is there a way to auto sort rows based on a column. I have one column with drop down and want the rows to all sort based on the order of the drop down. If I add a row or change that dropdown in column I want the rows to auto sort. Right now I have to right click the column every time to sort when data is changed
-
#INVALID DATA TYPE on SUMIFS formula
Hi. I am using this formula to count the total $ amount of all values in one column if the date in another column falls within a specific year. =SUMIFS({Incentive Location Audit Range 15}, {Incentive Location Audit Range 7}, YEAR(@cell)= 2023 ) {Incentive Location Audit Range 15} is a currency formatted column (US$ values)…
-
Is there a way to use Automation to update a Duration column?
I have a helper column currently that checks to see if a task is required or not, and I want to set my duration to 0d if it is not required. Right now, I am doing this manually as I can't see a way to get automation to update a Duration column using the "Change a Cell Value" option. Is there a way to do this via Automation?
-
Automatically Copying Cell Data in a Row
How do I automatically copy "Bill to" Name, Address, City, State, & Zip information to corresponding "Jobsite" cells, when the information is the same, by simply checking a "Same As billing" Checkbox on a Form? I tried this by using a formula on the sheet, and it worked well on the sheet but, when new "Forms" were…
-
Date Formula Help
I am trying to create a formula to pull a date into the Future Date column based on the report frequency and due date entered. =IF([Report Frequency]@row = "Yearly", DATE(YEAR([Due Date]@row) + 1, MONTH([Due Date]@row), DAY([Due Date]@row)), "") Above is what I entered, but it is throwing an invalid column value error. Can…
-
How to collect contacts to the "assigned to" column
HI, I'm trying to build flow in my project set-up to handle the "assigned to" column and as I have around 200 tasks in my standard project I want to make it as easy for me as possible :-) I have a sheet for estimating time spent on tasks where I assign time for each task in a column for each profession. Some tasks are…
