I have recently gotten into using Dashboards within Smartsheet, amazing. Is there a way to display today's date in a widget?
Hi Scott. You could populate a sheet with the formula "=today()", and use a metric widget to populate that value to the dashboard.
If you want something more complex, like embedding it into a sentence, you could leverage concatenation and date formatting formulas.
I'll check out the references you listed. I have tried using the =today() approach in another sheet, but unless I am missing something, you have to open that sheet in order for the date to change on the dashboard. I tried this last week, on March 15th. This morning I opened my dashboard and the date read "March 15, 2019". After I opened the sheet which contained the date, it updated and populated my dashboard correctly.
Having a date, and even a time option on the dashboard seems like it would be a valuable addition. My team has come to rely on our Development Dashboard and I would love to make it even more useful.
I see what you mean. Unfortunately, I don't have a better answer, and from research, it looks like an existing issue. See the response in the community post below from J. Craig.
One more note - looks like J. Craig found a workaround leveraging a third party app called Zapier.
Hi Scott & Josh,
Zapier is excellent, and an automatic way for it but another way would be to use an update request to update daily and then today's date would update as well.
Let me know which method you prefer, and I can give more information.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Josh & Andree,
Thanks guys, I will check it out! I appreciate the help.
Please can you give a bit more information on "use an update request to update" as I can see a similar option in the edit interaction drop down menu. How do I do this interesting option?
Happy to help!
You'd set up a daily update request in a helper sheet called Today where you would have a cell linked to all other sheets that need to be updated.
Let me know if I can help in any way!
Have a fantastic day!
Workflow Consultant @ Get Done Consulting
Thank you for the pointers.
I have now set up a helper sheet with today and an update request.
I could not figure out how I will make the sheet do some thing like : Date = Date +1.
The screen shot of update request is attached for referenece.
There is a second way to create an update request where you can select that it should send recurring (Daily). If you go to the Row Menu and choose to Send Update Request for a row and cell, we can call Today and then link that cell to the other sheets that should update.
I am struggling with the same issue. Please can you elaborate further on how the row and cell can be updated automatically once an update request is sent? From my understanding, an update request is basically an email to the person to whom we are requesting the update from. Is there a way to automatically update dates for a smartsheet on a daily basis without a manual update from someone daily?
You would have to answer the update request but if you get it on mobile or in the web version, it's quick.
Hope that helps!
I know that this thread was posted some time ago, but as I was attempting to do this same thing, I came across it and thought I would share the solution I came up with in case anyone else happened upon the thread trying to do the same.
I made two sheets both with the same column setup, one was empty, one has the current date using a couple of date formulas and VLOOKUPS to change the numeric results into text:
=VLOOKUP(WEEKDAY(TODAY()), [Day-Number]:[Day-Name], 2, false) + ", " + VLOOKUP(MONTH(TODAY()), [Month-Number]:[Month-Name], 2, false) + " " + DAY(TODAY()) + ", " + YEAR(TODAY())
I made a column in this sheet to use for automation, and in the first blank row entered a unique value (I just used a number, "123456", but it could be anything. I then used an automated workflow task in the sheet with the data: The trigger is when a date is reached, and it repeats every day, and is set for 4:00am. The conditions are for the column set up for automation when the row contains the unique value I specified (123456). The action to perform is to move this row to the blank sheet that I made that is a structural duplicate of this sheet.
In that second sheet (which now has one row of data in it with that unique value in the automation column), I made another automated workflow task: The trigger is when a date is reached, and it repeats every day, and is set for 5:00am. The conditions are for the column set up for automation when the row contains the unique value specified (123456). The action to perform is to move this row back to the original sheet with my current date data in it.
What this will accomplish is to move data back and forth forcing Smartsheet to automatically enter and save the sheets in question, thus refreshing the calculated date and updating your Dashboard. Of course if anyone has any easier methods, I'd love to hear them! And I think it would be wonderful for the current date/time functionality to be built into the Dashboard widgets, I think it adds a very nice element of professionalism to have them present when looking at them.
Has anyone come up with an easier method of getting today's date show up on a dashboard other than creating an automation workflow or doing the VLOOKUP that was mentioned above?
This can't really be that hard, can it? 😋 (from a guy that has a problem even manipulating the simplest formulas).
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.