Sign in to join the conversation:
When using reports, the fields are not calculating simple math equations. Any ideas.
Hi,
Unfortunately, it's not possible at the moment to do calculations or use formulas in reports, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
All formulas and calculations have to happen on the sheets.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I'm using a sheet for a project plan. I have a % Complete column and a manual dropdown column for Status (options are Not Started, In Progress, Completed, At Risk, etc.). I want to change the Status column to "Complete" when the % Complete for a task is changed to 100%. Screenshot of my automation set-up is below. Can…
Hi, I have a large project plan, and sometimes I get lost among all the information when trying to locate specific tasks in the Gantt chart. Does Smartsheet have a feature similar to Microsoft Project that allows you to quickly scroll to or find a task?
We have multiple projects for 150+ countries and we want to create a heatmap style grid to track which project is live in which country. Ideally, we want to convert this grid into a timeline, what would be the ideal way to create this smartsheet?