MrJoshMiller

Google Spreadsheet Formula.

Sep 26th, 2013
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. Google Spreadsheet Formula.
  2.  
  3. Search for one column that has text. If present, pass through another column's value. If not, append a bit of text.
  4.  
  5. =IF(IF(IFERROR(SEARCH("Sandbox",A2),0),0,1),CONCAT("https://drupal.org/project/",D2),D2)
Add Comment
Please, Sign In to add comment