# Show only if updated?

**URL:** <https://community.glideapps.com/t/show-only-if-updated/4470>\
**Category:** Ask for Help\
**Created:** [February 10, 2020, 3:36pm UTC](https://community.glideapps.com/t/show-only-if-updated/4470 "2020-02-10T15:36:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![James\_Campbell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james_campbell/32/3400_2.png) [@James\_Campbell](https://community.glideapps.com/u/James_Campbell)\
**Post date:** [February 10, 2020, 3:36pm UTC](https://community.glideapps.com/t/show-only-if-updated/4470/1 "2020-02-10T15:36:59Z")

</div>

Hi Guys,

I run a calculation in Sheets based on the entries in the app, but the calculation only runs if the app is updated. Until it refreshes, the app is showing the wrong calculation. Is there a way to show the cell where the calculation is happening only after the app has refreshed so it’s not showing the wrong result?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 10, 2020, 6:26pm UTC](https://community.glideapps.com/t/show-only-if-updated/4470/2 "2020-02-10T18:26:44Z")

</div>

You can do some basic math within the app by creating a Match column in the data tab. If you are doing something more complex in your sheet, then there will be a delay between when the data is submitted, calculated in the sheet, and then returned to Glide. I haven’t been able to think of a good way to hide a value temporarily. Here is a thread where we tried to come up with a solution to a similar problem. Right now you can’t compare to column values to see if they match or not. You could create a column value in your sheet with the current date/time. Then when it updates to Glide you can display the date/time as a “Current As Of:” value. If I think of a solution, I’ll let you know.

> [@How to handle this with "App: Sales"?](https://community.glideapps.com/t/how-to-handle-this-with-app-sales/4357/8):
>
> hmm, that surprises me, but like I said, I haven’t really played with the buy button. I did give it a try in staging and now I see what you are talking about. I wonder if that’s something Glide could change since this is a good use case. I was thinking you could use the template column to encode the SKU and event Id into description, then split it apart later once the purchase is made, but it doesn’t look like that information comes into the App:Sales sheet. \* Disclaimer, I started with the …

---

<div class="post-metadata">

**Author:** ![James\_Campbell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james_campbell/32/3400_2.png) [@James\_Campbell](https://community.glideapps.com/u/James_Campbell)\
**Post date:** [February 10, 2020, 7:09pm UTC](https://community.glideapps.com/t/show-only-if-updated/4470/3 "2020-02-10T19:09:48Z")

</div>

That’s not a bad option. At the moment, the solution I’ve got is to show the details of the current calculation. That way, whomever is using the app, they just need to make sure that the details they’ve entered match the details of the current calculation (height, width, and quantity). At least for now, this is working.

 ![Untitled-1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a2c35a153ae0d99cb22800e0414e066b59463946.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 11, 2020, 1:23am UTC](https://community.glideapps.com/t/show-only-if-updated/4470/4 "2020-02-11T01:23:20Z")

</div>

Wish I could help more. I’d say to give the math column a shot. You could also use template columns to possibly get the ‘$’ in your result. Also look into relation and lookup columns to help get whatever other values you need for your calculation. If it’s all easily obtainable, then you could to the math in Glide and get instant results.
