Forum

Hello, For a formula based solution it is of course easier if you split up the dates and times to helper columns, then you easily can use the MINIF...

Hello Jaginder, In my opinion I think you should go with a rebuild of your data. The idea you have to gather all loans into one table/sheet is corr...

Hello Angelo, Glad I could be of help. Br, Anders

Hello Tony, Why don't you simply create a report in ServiceNow? I assume your exports comes from the Incident Management system from ServiceNow ITS...

Hello Sherry, I am glad I could be of help. Sometimes we tend to miss the simple solutions just because we think it must be more difficult than so....

Hello, If you want to create a formatting rule based on other cell values than the cells you want to format, you need to create a rule using a form...

Hello Jaginder, Welcome to MOTH. Please describe your issue in detail, what is it that you need help with? It might seem obvious for you, but fo...

Hello, Sorry, no file attached. If you’re having problem with getting correct results using AND / OR logic then perhaps this article can give you s...

Of course this was posted in another forum as well.

Hello, It has gone several years now since I worked with Salesforce, so my answer is based on what I got to learn back then. No, Power Query onl...

Hello, Something in line with this result perhaps? In Power Query, add a custom column as a new step to your tbl_2396 query and add following fo...

Hello, The best training is of course to familiarize with the system, learning what can and can’t be done. There are lots of books and courses, som...

Hello, You need to play around creating some conditional rules to control what custom number format should be applied. I wonder of what good usage ...

Hello, See attached, if this is not the result you want then please give an example. I used the same formula as provided earlier. Br, Anders

Hello, You can use following formula to get what you want. =IF(AND(I8=I9,I9="Yes",B9=C8),(C9-B9)-1, IF(AND(I8=I9;I9="No"),NA(),C9-B9)) Br, An...