-
Find and Return
Good morning gurus! I need some magic to find a return all instances of information in an external sheet. For example, I need to find all instances of "ABC" in the Material Name, and return the associated Batch number. All the formulas I try will give errors or only give me the data for one instance. Any ideas? Thanks in…
-
COUNTIF imparsable
I'm using the below formula in a Sheet Summary field to calculate how many rows have a value over .7. It keeps coming back as imparsable. Any ideas? =countif([Device1]:[Device1]), >.7)
-
Dashboard - Show progress using project phases not %s
I'm trying to create a visual in my dashboard that allows me to show where the project is at based on our standard project phases. Vertical axis - list of project names Horizontal axis - Project phases (01-Kickoff, 02-Discovery, 03-Build,...etc.) Right now I can only show % complete but I'm trying to show the additional…
-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
-
Returning a BLANK cell with IFERROR
Good Morning. I am trying to make this formula return a blank cell instead of #INVALIDDATATYPE if not using the IFERROR syntex or #UNPARESABLE how I currently have it built. What am I missing? =NETDAYS([Projected Delivery]@row, [Cleared RCI]@row) - 1, IFERROR(@cell), 0) Thank you!
-
Formatting in sheet summary reports
Hi, I'm changing my financials from USD to NZD and decreasing the decimals to nil. Interestingly, though I save the sheet and refresh it, my summary sheet report still shows the two decimals and USD instead of NZD. I though both the info in the sheet and the summary report were connected? Now I have to go field by field…
-
Random Form Questions
In order to socialize safety on our job sites we have a process called "Safety Lives in Conversation". A supervisor talks to a trade worker and asks them three questions while filling out a small paper form. Once you fill it out and tear it off, the next form asks 3 different questions. The note pad contains 10 unique…
-
COUNTIFS, IFS & OR Function
I'm having difficulty getting this formula to work. I'm trying to pull data from several sheets together if they are a certain contract type and a contract status and blank if the count is 0. Could someone please help? Thank you! =IF(COUNTIFS({Sha3}, ="Distribution", {Sha1}, OR(@cell = "Customer Legal Review", @cell =…
-
How do I show a blank/no value if none of my logical expression is true?
When a date is present in a field, I'm calculating 4 weeks ahead of that date, else I want it to be blank. This is returning an #incorrectargumentset. Thanks! =IFERROR(IF(WEEKDAY([End Date]16) = 1, ([End Date]16) + 30, IF(WEEKDAY([End Date]16) = 2, ([End Date]16) + 29, IF(WEEKDAY([End Date]16) = 3, ([End Date]16) + 28,…
-
Using formula from duration/work columns
Hello, I am trying to create my own allocation % formula on my project plan sheet. I am utilizing a work column and a duration column. The work column represents how many hours of hands on the keyboard work that a task requires to be completed. Duration is the amount of days a task takes to be completed. My team enters…