-
combining them in the same column
Hi, Can we show the date and time by combining them in the same column? thanks
-
How to calculating the age of a cell in hours
Background - I have a Form, which outputs as a row in a Grid, an extract of which is as follows - The 'Date Raised' column contains a System-generated - Create (Date) value, and the 'Current Date/Time' column contains today's date (using the =TODAY() function). Problem - I am trying to find a formula-driven solution, which…
-
Currency view on Calendar
Having trouble showing currency view in my Smartsheet calendar. The data set it is pulling from has the right formatting. not sure what i may be doing wrong.
-
Can I set calendar view to open to today's date?
Hello, Last week we noticed that our calendar view was opening to a date several years in the past (Aug 2015) rather than opening to today's date (which it had been doing successfully all of 2021). This sheet was completed in 2021 so there are no dates entered that are prior to the creation date. I have changed the…
-
Embedding Calendar View to Confluence Page
Is it possible to embed a Calendar View from Smartsheet to a Confluence page? Would like to be able to maintain an events calendar in Smartsheet and have it update in Confluence. Thanks!
-
Best Method to Track Resource Loading by Individual & Their List of Tasks
Hello, I work in manufacturing and have used Smartsheet in the past and taken advantage of the "issues/task" list template for a specific capital project and modified to fit my needs. It worked great. I set up a very simple dashboard to show status of tasks, # of tasks assigned to each person, etc. However, that was for…
-
Conditional formatting - Calendar view
I would like all of the events to be a different color on the calendar I am creating however if I use "type of event" as the condition, they all end up the same color on the calendar even if I set them differently. I have tried setting AND conditions as well but they end up the same color. For example, if I set "Moda…
-
Calendars
Hello! The company I work for does not have the Calendar App in their plan (at least not for now), so can anyone share their best calendars tips and tricks to show their Holiday staffing without using the calendar app? Any and all suggestions welcome! Elizabeth aka Smartsheet's #1 Fan 😅
-
How can I set a dynamic filter on a report to auto change to today's date?
I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than…
-
Using Calendar for Time Off?
Has anyone utilized the Calendar for time off/vacation requests in shared format? Meaning that a department with multiple staff utilizing to request time off color-coded and then once granted this would change to different color-coded status. Would love to know if anyone is using successfully or if they have created a…
