google sheet formulas
hi, i'm really struggling to send the result of a formula in a gsheet into a gslide. it seems that zappier doesn't know how to read the result of a formula in a gsheet. writing the formula in the zap is quite impossble cause i've a lot of formulas with reference to several sheets (vlookup) etc.. is there a quicker way to let  zappier take the result of the formula in my slide ?
sorry for misunderstanding the core issue with this one,@tom\_mgdi. i just tested a find row step using a simple formula (just a sum function) and the zap was able to search based on the value of the result of the formula (ie the result of the sum). this tells usthat the zap is failing specifically for query or import range formula. it’s likelynot finding the valuesbecause lookup formulas and import formulas will only show the imported value while they are being observed in google sheets, otherwisethey either appear as blank or as the raw function. if you have access to the other sheet that you are using the function to get results from, it may be worth adding an extra “lookup spreadsheet row” action to the zap, to get the information from that row in the other sheet, then combine the two rows later on.
[@jonchen](/t5/user/viewprofilepage/user-id/85086) Correct, I don't believe there is any out of box methods to display something like that.  Would require levering the API to build something to expose the results on something like a leaderboard.

Tracking it would only be possible outside of Khoros manually as well - Nothing in reporting could provide the results as the formula is doing the calculations - You could pull the data out of Khoros and then manually calculate it in Excel or something like that (I've seen a few Communities doing some manual things like this to track/gamify). tab visibility is currently only based on the user profile sheet. if you want to control tab visibility from a value in another sheet, you need to use relation/lookup, relation/rollup, or single value columns to bring in whatever value you need into the user profile sheet.

[https://docs.glideapps.c…](https://docs.glideapps.com/all/reference/design-and-structure/visibility-conditions#tab-visibility) mapping is the 3rd rail of cad software. most pd's cannot maintain gis files, etc. the best solution i've seen is what we have now. our system uses google maps (browser based) with a system layer over it. so, either it geo codes the address after the call is saved or it uses the lat/long we enter on the geo file in our system. we can also geo code officer alerts to the map. so much easier. we also have browser based maps from our gis analyst that has more parcel info but only dispatchers reference it. best bet is to add a layer over the google map with your boundaries. i actually spoke to my vendor and they are going to add a boundary layer to our stuff as well. it's a good idea. in case this is of further interest to anyone: i made some minor modifications to [@joels](/u/joels)' code to fetch the predicted values (plus cis) from effects only, which can then be fed into a ggplot. as long as ggeffects does not display confidence intervals, this allows to use the internally consistent pre… Hi Djhenry,
  

  
When you right-click a sheets tab, you can select all sheets. When you have done that, you can insert a row and enter all the information and all sheets wil contain that information.
  

  
Best regards,
  
Trowa done. [links to api, release notes, derived formulas, etc](https://community.weatherflow.com/t/links-to-api-release-notes-derived-formulas-etc/2450) .

thanks for the request / suggestion [@vinceskahan](/u/vinceskahan) ! Katy.  Please try double-tapping it (that will enable it without you having to continue to hold it) and see if you're getting the same response with erasing.  The more information I can share with the team, the easier it is for them to look into it.  Sue. hi ulillillia,

try the pdfcreator

http://sourceforge.net/projects/pdfcreator/ you need a macro. a small extract of the four sheets may be uploaded to 
  
www.speedyshare.com without password. its kind difficult to understand in my POV but not impossible  

imagining it while reading


can you show some codes? or samples on what you want to achive?