I'm looking for a formula that will copy the contents of a row on one tab into another tab. I want this to happen when something is entered into a column on...
The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1745505309793":{"__typename":"CachedAsset","id":"text:en_US-...
Good morning, I would like to have your guidance on how to programme this spreadsheet the way my Supervisor wants. If you open the sample file, between rows 3 to 5, the engineer will key in th... Hello Jeffry I think this is related to "Problem with IF function". You can use a m...
The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1744658874051":{"__typename":"CachedAsset","id":"text:en_US-...
The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1745505307000":{"__typename":"CachedAsset","id":"text:en_US-...
Hello Jeffry I think this is related to "Problem with IF function". You can use a mix of Ingeborg's and my solution. Insert an additional column after "Duration" with this formula and copy it down. =LOOKUP(I3,{0,10,56.0001},{"Hot","Warm","Cold"}) ...
=COUNTIFS($A$3:$A$5,C$11,$K$3:$K$5,$K12) Dear Mr. Detlef, That was very helpful. Hope you could help me to resolve one final hurdle with the spreadsheet. Everyday, new data will be keyed in into the row 3 to 5. Meaning, the engineers will delete yesterday's data and key...