Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
=LET( matchQA,ISNUMBER(IFERROR(SEARCH("qa",D2),"not qa")), matchTest,ISNUMBER(IFERROR(SEARCH("test",D2),"not test")), matchProd,ISNUMBER(IFERROR(SEARCH("prod",D2),"not qa")), whichEnv, IF(matchQA,"env_qa", IF(matchTest,"env_test", IF(matchProd,"env_prod","missing named env") ) ), IF(whichEnv="missing named env","invalid env",ISREF(INDIRECT(whichEnv))) )
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
