10

Hello, I have a Master Sheet and a Roll Up sheet based on the Master. The Roll Up uses a lot of formulas, including the "TODAY()" function. Apparently, the Roll Up will NOT refresh to reflect the data that came into the Master unless I physically go in to the Roll Up and "activate" it by scrolling around in it and re-saving it. This is absolutely ridiculous and unacceptable. Are there any work arounds? Any automated saving procedures? By automated, I mean that a human being is not necessary for it - the sheet just activates and saves itself when new data comes in. This is super important because the Roll Ups come out Daily and are very sensitive in terms of accuracy (I work in a hospital). Thank you!!!

Industry
Department

Comments

Hi Eva,

Zapier is a great option for this scenario. Is that an option for you?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

In reply to by Andrée Starå

Thank you for the tip! I've never heard of it. Just looking at it online, it seems like our IT dept would have to get involved and allow me to download it, my dept would have to agree to pay for it etc. I was hoping for a fix within Smartsheet. It seems like this problem is really serious. Why have functions that negate the very purpose they have. Sigh. Not happy with Smartsheet right now. Not sure how to resolve it. Thank you anyway! I know you didn't write the software.

In reply to by Andrée Starå

Hi Andree, the Update Request will only work if that request goes to a living human being. I am trying to get away from that. I need the Roll Up to automatically update when new info comes in. I really don't understand why that is not a given. What is the reasoning behind even having a roll up if it doesn't update and a person has to go in and do it themselves all the time? Makes zero sense. My company has decided to drop Smartsheet and the IT is now getting involved with doing something else. However, in the meantime, this remains a huge issue that is just ridiculous. I know it's not your fault, I am just really frustrated because I put a LOT of time and work into all the formulas and sheets only to not have it work in terms of something that should be a norm.

In reply to by Eva M

Sorry to hear that your employer decided to drop Smartsheet. I understand the frustration, and I would be surprised if this isn't addressed soon. I'd recommend waiting for what's coming at Engage this year.

Can I help in any way?

In reply to by Andrée Starå

Andree, you helped already!! This is not your fault. Just knowing it's kind of a glitch and not something I am doing wrong is enough. I did submit the enhancement ticket. You know, now that you ask...is there a way to have a formula looking at the last "x" amount of days that would NOT include today? Meaning that I wouldn't have to use the TODAY function? Thank you!!

In reply to by Eva M

Unfortunately, as far as I know, it's not possible because you must have a reference to today's date. I'll get back to you if I think of something else.

I agree, Eva..

I was hoping that there would be a way to run a daily "touch" action within the automation options. Having to rely on a third-party software to do a common/generic routine is like hiring an exterminator every time you see a mosquito.