-
Design Form
Hi there, I have a situation where I need your expert advice. I have build other forms with drop down and check box and logics but unsure if this at all can be done. Can we have four fields associated with one KPI where 2 of them will be Numerical and other two $ like
-
I want to calculate the number of days using two date fields, and if blank use today.
I want to calculate the Days to Build field by counting the number of days from the Ready for Customer QA minus the Build Start Date. And if there is no date in Ready for Customer QA I want to know how many days from today - Build Start Date
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
Parent Row Formula Disappears
I have the following formula on the parent rows in my sheet that I use to track allocation percentage based on status of projects/non-project assignments however when I navigate off of the sheet, the formula disappears from every parent row. Based on the audit history, the last person to update the sheet shows as updating…
-
Why can't I use this If statment in my Sheet Summary
I would like to create a Metric Widget that will check and see if there are enough parts in an assembly to build that assembly. Thank you
-
Change Status Ball for Old Row Entry When New Entry of Same Name is Created
I have a sheet tracking facility access qualifications for contractors; I need to change the status ball for a previous entry when a new row is created of the same contractor. Basically, when "Ron Cook" has a new row entry, change the status ball on the previous "Ron Cook entry to trigger automation to move the old row to…
-
COUNTIF + CONTAINS - how do I incorporate them both?
I'm trying to count how many times a value is used in a column. Sometimes the values are alone, sometimes there are multiple in a cell. I got my COUNTIF formula down: =COUNTIF({Christoph Comms Tracker Audience Category}, "Select SMG Employees") But I want to change it so it counts cells that include the value (along with…
-
using COUNTIFS with contains
Hello, I'm trying to count the number of rows where deployment complete or cancelled is not checked, where Deployment Type is "New Deployment" and Deployment Tier is either "Plus" or "Plus Unlimited." The formula I'm using is getting an Invalid Operation error. =COUNTIFS({Deployment Complete}, "0", {Deployment Queue…
-
Index Match returning blanks when there is a Match?
Hello, I have a nested IFERROR Index/Match that is returning a Market Code based on a Unique ID. Formula looks more complicated than it is: =IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(INDEX({CA}, MATCH([MPL #]@row, {CA}, 0), 2), INDEX({DE},…
-
Check box in sheet when email address entered in a form matches an existing email address in a sheet
Hi, I'm trying to get my dashboard on employee training to automatically remove rows from a report when a specific user responds using a form. I have the responses from the form automatically moving to another sheet/report, but then I want that user to be removed from the 'yet to respond' report in the dashboard. My…