-
IF formula help needed
I am getting #UNPARSEABLE from the formula below. =IF([Risk Score]@row > 200, ".40", IF(AND([Risk Score]@row > 149.9, [Risk Score]@row <= 200), "0.35", IF(AND([Risk Score]@row < 150, [Risk Score]@row > 99.9), "0.2", IF(AND([Risk Score]@row < 100, [Risk Score]@row > 49.9), "0.03", IF([Risk Score]@row < 50, ".02")))))))) I…
-
Combining Formulas in 1 Cell
Hello, I have a column with this formula: =PARENT([Task Name]@row) which is assigning my rows the name of the parent so I can create swimlanes in the card view sorting my tasks by the parent project name. In the same column I would like to also have an option to override the first formula with this formula:…
-
Date Formulas
I am looking to set up a Date function. I have multiple dates on a sheet, I need to set a column or multiple columns up with a formula to automatically calculate. Example 1 column has a Start date (date column property) I want another column to calculate 21 days ahead when that will bill, and so on for each 21 days.. Do I…
-
Filter by Label Color for Card View
Hello, I am using the Card view to set up a Kanban board for our ongoing product enhancements. I have setup filters to search for keywords to be able to filter to see only certain cards. I have also setup the task label colors to label cards together by color as well. Is there a way to build a filter that can sort by the…
-
I have two questions regarding a column property and a row change.
1. Column property I had set a column to be an auto-number/system – modified date setting. I originally had a Record a date workflow and had some dates already in there. I made the column property change to replace the workflow. Because I did not modify any of the cells/rows and only the column property to auto generate…
-
Combining two actions into one formula
Hi, I am attempting to set the value of a drop down based upon other values in my sheet. =IF(AND([Subscription End Date]@row <> TODAY(), [Add Request Type]@row = "Edit Seat"), "Active", IF([Remove Request Type]@row) = "Subscription Cancellation", "Cancelled") The first argument in the string works great. When I attempt to…
-
SumIfs with multiple criteria from different sheets
I am needing some assistance with Sumifs with multiple criteria from multiple sheets. We work out of a install and completed sheet for scheduling. I am trying to get the information from sales into a reference number sheet since reports don't give accurate average percentages. This formula works fine for pulling YTD…
-
Creating a Subscription End date
Hi all, Trying to come up with a formula to advance a date by the appropriate duration based on an entry in an order form. For instance, When the customer orders a subscription for one year (Annually in the attached example), I would like to have the subscription end date calculate 365 days from the subscription start…
-
Highlight rows with elapsed time in Duration column
I would like to setup a formula /if statement, that looks in the standard "duration" column which would typically be days or weeks, and puts in another column 24 if duration type is "elapsed" (ie e2wk) or 8 if its just a standard duration (ie 2wk) Is there a way to use the duration elapsed/non-elapsed column to do this?…
-
=countif
i am trying to count all cells that are greater then 0 but only on certain cells, not the whole column as shown in print screen i would also like to have a formula that shows cells in column that are greater than 0 but less than 100 what is the right formula? thanks in advance
