Sign in to submit new ideas and vote
Get Started

Allow formulas to function in reports

Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.

20
20 votes

Idea Submitted · Last Updated

Comments

  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭

    Agreed. The 'live' conditional formatting and formula calculation that a sheet provides is great, to have that in Reports would be outstanding. It's a constant training item to explain to 1) fill in the data, then 2) hit the refresh button, 3) hit save on the prompt from the refresh button, then 4) see your updated results (which might take you to a view of a different portion of the screen than you were previously on.

  • Hi

    We have the same issue, it is very disappointing for us as we have developed a “Legislation Compliance” tracking system that can’t be relied upond. Each morning a report is run to see if any compliance items are due for that day and report those that are overdue. The overdue formula as you known won’t activate unless someone opens the sheet.

    After logging a ticket with Smart sheet, their suggestion was to “vote” our support for a “feature” and suggested your item. The problem is if you look through the requests (features), this issue has been around for a long time (at least 2018). We needed a solution now or look at using something else, so we decided through the inaction of Smartsheet to look at a work around, which is working for us.

    Hope the following info my help you (and others)

    Background for understanding.

    Our Council has approx. 84 compliance items that need to be reported on throughout the year. These items spread across 5 directorates and 24 units. For each compliance item, the system checks to see if the [Due Date] = Today(). If that is the case another check is to see if a unit has advised if the compliance report has been submitted [Completed Date] <> NULL.

    So if [Due Date] is Today() and [Completed Date] = NULL include this item in the daily overdue report.

    To make the sheet formula calculate the result without having someone open all of our sheet we added a help column [Force Refresh] to each sheet. Then created a workflow that runs every morning (6am) that checks for [Due Date] = Today(). If this condition is true the workflow writes text (Change cell value) into the [Force Refresh] cell. For us this makes the sheet formula to update the sheet and therefore the item appears on out overdue report.

    If I have been unclear or you need more infor: [email protected]

  • Hi

    i think it would be great to have the option to add formula in the report view, similar to the sheet view. even if it is basic maths like adding two values together.