-
Need a box checked if one of two criteria is met
Hi! I have a column and I need the box to check if a student's disability is Intellectual Disability or Multiple Disabilities. I have the formula correct if it's just one: =IF([Primary Disability]@row = "Multiple Disabilities", 1, IF([Secondary Disability]@row = "Multiple Disabilities", 1, IF([Tertiary Disability]@row =…
-
Formula is resulting in carriage return and quotes around text
Here is my formula: =[Client Name (Avi)]@row + "-" + LEFT([Request Category]@row, 1) + "-" + MID(Created@row, 7, 2) + "-" + [Request ID]@row + "- " + JOIN([Services Requested - Utility]@row + [Services Requested - Waste]@row + JOIN(" -P")) When I copy/paste the cell (or export to Excel), the text looks like this (two rows,…
-
How To Collect Data based on date and post to proper month column
Hi All! I have a several large projects running in a portfolio. The projects are all construction in nature and with each project there are subsections of construction each with target completion footage and target completion dates. I would like to build a report to show me the total build footage across the various…
-
Create a formula to total the individual values of a dropdown list from one column?
So I have a dropdown column that has 12 options and it does allow multiple selections. Each of these items is worth 0.5 value. I am trying to create a formula for another column to report the total value selected in this column by the end user. So if the user selects 3 of these items from the dropdown, I need the formula…
-
Working on creating an IF statement that has multiple conditions to be met.
I am working on trying to control the Harvey Ball colors based on status AND dates. The conditions I am trying to use are: If status is "complete”, then blue If start date is in the past but status is “not started”, then Harvey Ball, yellow If finish date is in the past and status is not “complete”, then Harvey Ball, red I…
-
Percentage Formula
I am trying to obtain the percentage of the following: Orders On Time Orders In Full Orders On Time in Full My formulas are as follows: Orders On Time - =ROUND(SUM([On Time (OT) %]1 / [Order Count]1)) + "%" Orders In Full - =ROUND(SUM([In Full (OTIF) %]1 / [Order Count]1)) + "%" Orders On Time in Full - =ROUND(SUM([On Time…
-
Formula to count distinct values in a column that contain a certain text string
I am looking for a way to count distinct values in a column, but only if the values contain a certain text string. For example, in my Fruit column, I'd like to count the unique values that contain "Large." In this case, the number should be 3. Fruit Apple - Small Apple - Medium Apple - Large Orange - Small Orange - Medium…
-
Cell Linking / Autopopulate
Can I use cell linking to auto-populate the data from my main sheet to a second sheet? As I enter new accounts in my main sheet, I would like specific columns to auto-populate in the second sheet. Is cell linking the best option to perform this task?
-
Sum collect contain formuale
Hi, I am trying to use the SUMIF Contains or INDEX Collect contains but is not coming out right. I am trying to Sum total those projects which Contain Alpha
-
Box checked 5 days prior & if Status is not "Completed" or "N/A"
Afternoon I'm trying to have a box checked 5 days prior to an entered date & if the Status column drop down is not "Completed" or "N/A". I have the 5 days prior figured out but not the Status, any help would be greatly appreciated. =IF(AND(ISDATE([Estimated Completion Date]@row), TODAY() >= [Estimated Completion Date]@row-…
