wich macro refers to spell slots?

i use the dnd5e OGL sheet, i want the dice roll to happen in the spellcard, instead of the attack becouse i think the UI in the spellcard is prettier, but how do i add dice rolls per spell level when using the sheet? i maneged to make it roll the base level dice just fine with [[5d8]] on the sleep spell, but how do i add 2d8 per spell slot used qhen upcasting?

That depends on the spell. Usually the best bet is to pull that from an existing spell that does it and duplicate it.  Which spell are you trying to do? 

correction: how to add 2d8 for each level above level one that i upcast the spell slot?

on this exemple i'm trying to create a macro for sleep, 5d8 + 2d8 for each spell level above 1, i tried [[@{spell_level}-1*2d8]], [[@{level}-1*2d8]] and a few others, but i can't make it work when i choose to upcast the spell.

it still gives me the upcasting option but it never works.

how do i reference the spell slot level on the macro and make it add more dices instead of multiplying the dice result?

I am not sure why you are trying to make a macro out of Sleep. Sleep already does all this.  If you are just trying to modify the spellcard to display the results instead of attack form, this is how you do that:  The key is to copy the Query that the upcast spell is already using, then use that.  So using Sleep as the example:  1) I drag Sleep from the Compendium to the character sheet.  2) I switch Sleep from Attack to Spellcard 3) I click Sleep and cast it. The game asks me for the spell level.  4) I click on the Chat box (where you type), and then hit the up arrow on my keyboard.  5) Copy that it will look like this (I bolded one section):  @{Kreb Whoabro|wtype}&{template:spell} {{level=enchantment ?{Cast at what level? 1|Level 1,1|Level 2,2|Level 3,3|Level 4,4|Level 5,5|Level 6,6|Level 7,7|Level 8,8|Level 9,9} }} {{name=Sleep}} {{castingtime=1 action}} {{range=90 feet}} {{target=Creatures within 20 feet of a point you choose within range (in ascending order of their current hit points, ignoring unconscious creatures)}} {{v=1}} {{s=1}} {{m=1}} {{material=A pinch of fine sand, rose petals, or a cricket}} {{duration=1 minute}} {{description=This spell sends creatures into a magical slumber. Roll 5d8; the total is how many hit points of creatures this spell can affect. Creatures within 20 feet of a point you choose within range are affected in ascending order of their current hit points (ignoring unconscious creatures). Starting with the creature that has the lowest current hit points, each creature affected by this spell falls unconscious until the spell ends, the sleeper takes damage, or someone uses an action to shake or slap the sleeper awake. Subtract each creature’s hit points from the total before moving on to the creature with the next lowest hit points. A creature’s hit points must be equal to or less than the remaining total for that creature to be affected. Undead and creatures immune to being charmed aren’t affected by this spell.}} {{athigherlevels=When you cast this spell using a spell slot of 2nd level or higher, roll an additional 2d8 for each slot level above 1st.}} 0 {{innate=}} {{savedc=@{Kreb Whoabro|spell_save_dc}}} 0 @{Kreb Whoabro|charname_output} 6) I take the bolded section and I use that to tweak the description.  "Roll 5d8; the total is how many hit points of creatures this spell can affect." becomes:  Roll [[(?{Cast at what level? 1|Level 1,1|Level 2,2|Level 3,3|Level 4,4|Level 5,5|Level 6,6|Level 7,7|Level 8,8|Level 9,9}+5)d8]] (5d8); the total is how many hit points of creatures this spell can affect. So now my new description in the spell goes from this:  This spell sends creatures into a magical slumber. Roll 5d8; the total is how many hit points of creatures this spell can affect. Creatures within 20 feet of a point you choose within range are affected in ascending order of their current hit points (ignoring unconscious creatures). Starting with the creature that has the lowest current hit points, each creature affected by this spell falls unconscious until the spell ends, the sleeper takes damage, or someone uses an action to shake or slap the sleeper awake. Subtract each creature’s hit points from the total before moving on to the creature with the next lowest hit points. A creature’s hit points must be equal to or less than the remaining total for that creature to be affected. Undead and creatures immune to being charmed aren’t affected by this spell. To this:  This spell sends creatures into a magical slumber. Roll [[(?{Cast at what level? 1|Level 1,1|Level 2,2|Level 3,3|Level 4,4|Level 5,5|Level 6,6|Level 7,7|Level 8,8|Level 9,9}+5)d8]] (5d8) ; the total is how many hit points of creatures this spell can affect. Creatures within 20 feet of a point you choose within range are affected in ascending order of their current hit points (ignoring unconscious creatures). Starting with the creature that has the lowest current hit points, each creature affected by this spell falls unconscious until the spell ends, the sleeper takes damage, or someone uses an action to shake or slap the sleeper awake. Subtract each creature’s hit points from the total before moving on to the creature with the next lowest hit points. A creature’s hit points must be equal to or less than the remaining total for that creature to be affected. Undead and creatures immune to being charmed aren’t affected by this spell.

Note: If you are trying to make a macro button for Sleep so you don't have to reference the spell page, you don't need to do all the work above. Just turn the spell itself into a macro.  Drag the spell to the bottom of the sheet, that creates a button on the macro bar.  Click the button, then click the chat box and hit the up arrow, that will give you the command for Sleep. Put that into your macro.  Then you drag the button off of the macro bar.

that was closer, but it only adds 1 d8 for each slot, how do i add 2 d8 per spell slot? and yes, i'm trying to reference the spell page.

i figured how to add more dice per level, thanks, i probably wouldn't figure it out on my own.

i'm sorry but... 1 more question, how do i add cantrip progression to the spellcard? both for cantrip dice and cantrip beam progressions?

Oops, my bad, forgot about the 2 per spell level.  Spellcard cantrip progression: Same process, but check the attacks instead.  For example, drag Fire Bolt over from the compendium, click the attack, then do the steps I did above to find the level information for that.  Edit: [[round((@{Test2|level} + 1) / 6 + 0.5)]]d6 is an example of Cantrip progression. 

i was testing again... and for some reason at level 1 it always roll 6d8 instead of 5 at level 1 and even after changing it, it's only increasing the dices per level by 1, i have this macro: [[(?{Cast at what level? 1|Level 1,0|Level 2,2|Level 3,4|Level 4,6|Level 5,8|Level 6,10|Level 7,12|Level 8,14|Level 9,16}+5)d8]] , why isn't it increasing the dices correctly?

Here is the correct formula for that:  [[(?{Cast at what level? 1|Level 1,1|Level 2,2|Level 3,3|Level 4,4|Level 5,5|Level 6,6|Level 7,7|Level 8,8|Level 9,9}*2+3)d8]]

thanks, that really helped.