@Amyatzu I'm sorry, I don't have time to walk you through this step by step right now :( I mostly learned by lots of googling and experimenting and looking at how other sheets did things, hopefully you can figure it out, too!
Guides
Community created guides, helpful strategies, and more.
TOPIC | Auto Formatting Bios (Google Sheets)
@Amyatzu I'm sorry, I don't have time to walk you through this step by step right now :( I mostly learned by lots of googling and experimenting and looking at how other sheets did things, hopefully you can figure it out, too!
I figured it out something along the lines of
=IF (color codes in here on some way shape or form, then=color name in swsof)
=IF (color codes in here on some way shape or form, then=color name in swsof)
I figured it out something along the lines of
=IF (color codes in here on some way shape or form, then=color name in swsof)
=IF (color codes in here on some way shape or form, then=color name in swsof)
 XXX
|
xxx xxx |
         Were you expecting a modicum of rust? xxx xxx |
Wow! Where has this been hiding from me! It is super fantabulous! I'm going to be busy I see.
Wow! Where has this been hiding from me! It is super fantabulous! I'm going to be busy I see.
@Poisonedpaper This is amazing, thank you! *scratches head* Oh! So you sort of... code the bio once, and then replace the parts that are unique per dragon with spreadsheet commands. I am going to be tinkering for hours, aren't I. Thank you for sharing your findings! You're some kind of saint. :)
@Poisonedpaper This is amazing, thank you! *scratches head* Oh! So you sort of... code the bio once, and then replace the parts that are unique per dragon with spreadsheet commands. I am going to be tinkering for hours, aren't I. Thank you for sharing your findings! You're some kind of saint. :)
@Ithika Hahaha, thank you! I promise I'm not secretly a saint spending my time coding up Flight Rising spreadsheets ;D
And yes, that's basically it! Good luck tinkering, do show me if you get it working <3
And yes, that's basically it! Good luck tinkering, do show me if you get it working <3
@Ithika Hahaha, thank you! I promise I'm not secretly a saint spending my time coding up Flight Rising spreadsheets ;D
And yes, that's basically it! Good luck tinkering, do show me if you get it working <3
And yes, that's basically it! Good luck tinkering, do show me if you get it working <3
@poisonedpaper hahah, well maybe you ought to be canonized ;) Seriously, thank you - I can't imagine the time those spreadsheets represent!
I have decided to jump immediately in the deep and and try to automate a version of this bio. ;) So I will be pinging you in approximately five months, I think. Haha. But I do love adventure!
I have decided to jump immediately in the deep and and try to automate a version of this bio. ;) So I will be pinging you in approximately five months, I think. Haha. But I do love adventure!
@poisonedpaper hahah, well maybe you ought to be canonized ;) Seriously, thank you - I can't imagine the time those spreadsheets represent!
I have decided to jump immediately in the deep and and try to automate a version of this bio. ;) So I will be pinging you in approximately five months, I think. Haha. But I do love adventure!
I have decided to jump immediately in the deep and and try to automate a version of this bio. ;) So I will be pinging you in approximately five months, I think. Haha. But I do love adventure!
OOOOH my goodness this is glorious. *_*
I will be working for hours. XD But so worth it to give my Babs Nice Bios!
Thanks for making this, you are awesome!!
I will be working for hours. XD But so worth it to give my Babs Nice Bios!
Thanks for making this, you are awesome!!
OOOOH my goodness this is glorious. *_*
I will be working for hours. XD But so worth it to give my Babs Nice Bios!
Thanks for making this, you are awesome!!
I will be working for hours. XD But so worth it to give my Babs Nice Bios!
Thanks for making this, you are awesome!!