Comments
-
Below is an example. Bird created several cases today that are dated 7-20-2020
-
Andree - I figured out a method that works for me but it would have taken me 5X the time to figure this out if you did not provide your comments and advice. As always, Thank you So Much and Have a Great Day and Month! Carey
-
Closer =IF(AND(Combine Loc & Name1={Pad Inspection Report Sheet 7-7 2 [CombPN&L]:[CombPN&L]}, [QuarterYr]#={Pad Inspection Report Sheet 7-7 2 [QTRfiscal]:[QTRfiscal]}, 1,0) Or Should it be: =If(AND(MATCH($[Combine Loc & Name]@row, {Pad Inspection Report Sheet 7-7 2 Range 1})=TRUE, (Match([QuarterYr]#, {Pad Inspection…
-
RossL - I apologize. I did not see your request. You can see from the image that the [QuarterYr]# is not working. Also, I want to shift the Pad Inspection...Range to Pad Inspection [Loc...]:[Loc...] Format because setting it up as a Range does not work as Field Officers add more and more Rows.
-
修正=如果(和(结合Loc & Name1 ={Pad Inspection Report Sheet 7-7 2 [CombPN&L]:[CombPN&L]}, Quarter1= {Pad Inspection Report Sheet 7-7 2 [QTRfiscal]:[QTRfiscal}, 1,0)
-
Yellow background is automatically calculated and is normally hidden
-
Yes. So, it is a numeric 0 or 1. Thank you. Best as Always
-
I hear you. But that would be a shame. The date of the attachment or the data the case is recorded in a row could be days or weeks after the event as is in this case. I was able to change it by switching the type of field structure from automatic to just date. I am starting to wonder if I should not leave it at date. Thank…
-
You can see the correct date 7-21 and the forced auto date that cannot be changed
