I am looking at a template from smartsheets, and I liked that they had a starting next and ending next box on the dashboard. Would I be able to set this up with tasks in a row in a sheet? If so, how can I set this up?
You can do this by using the metrics widget on the dashboard.
Structure your rows with start and end date like this:
then, when you are on your dashboard, with the metrics widget created, select the row needed for the data.
next, change the layout of the widget to "Stacked" instead of side by side.
Finally, remove unnecessary data points from the metrics widget.
@SteyJ Am I able to have it so that it automatically updates with the project who's due date and start date is approaching the soonest? Or do I have to manually do this every time I want an udpate?
Sure. You can create helper columns, or summary fields by using a formula like this:
For end date
=INDEX([Name]:[Name], MATCH(MIN([end date]:[end date]), [end date]:[end date], 0))
For due date
=INDEX([Name]:[Name], MATCH(MIN([due date]:[due date]), [due date]:[due date], 0))
Something to consider, you will eventually need to add an IF statement to check whether a due date or end date has passed, this is usually done with a status column, but this is just this gist of how it would work.
@SteyJ I am not too familiar with helpers columns or summary fields. Would you be able to go into that a bit?
Sure. Helper columns are basically new columns created that work in the background of your sheet for calculations, etc. They are no different than a regular column, but they're considered helper columns because they have formulas in them to help the sheet do something additional -- such as show the soonest due date / end date.
Summary fields are the similiar, but they work alongside the sheet. You can then reference summary fields in reports, to pull statistical data about your sheet in one consolidated place.
side note: one of my coworkers actually recommended summary fields at Engage 2019 -- and he thinks he's the reason they exist! 😂
@SteyJ haha that's too funny about your co-worker! Thank you for all of the help, very informative.
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.