I'm looking for a way to project future event revenue projections in a dashboard. If I had revenue from Q4 and Q1, is there a formula to forecast Q2 data similar to excel? What formulas have you used before?
What logic would you use to forecast? Would it be an average of the two, the higher of the two, increase/decrease by the difference? It is possible using formulas, but you would have to determine the logic behind generating the forecast.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I just became Admin for our company. There are users with licenses that have folders by their names. They are unable to do anything but view the sheets/reports. How do I change the access so they can edit sheets?
I am a business user but Data Shuttle is not activated. How to activate it?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.