-
Put modified date into a Summary Sheet
I am trying to create a sheet that gets updated automatically every hour via data shuttle. I'd like to have a summary sheet tied to it that allows me to show some values and also show the date and time the last update occurred. Summary fields don't have all the options as normal, but very simply I want to take the data…
-
How to calculate time spent on a project using the Time Function?
Hello, I am trying to set up a time tracking sheet to track how our factory staff spend their time. I have "Start Time" and "End Time" fields in 24 hour format. I am trying to calculate the time spent (the difference between the start and end times). I found the Smartsheet article on the Time Function, however, their…
-
Resource Management: use : to enter time in minutes
As well as being about enter time 2.75 hours of time we would like to able to enter 2:45 for 2 hours and 45mins of work. This makes it easier for users to enter how long they have worked on things without having to work it
-
Can Smartsheet drawdown hours used and hours remaining in a report?
I'm creating a higher level report that summarizes data from a Smartsheet. This Smartsheet contains the number of hours staff are assigned to in one column. I have an allotted number of total hours that staff can draw from. I'm wondering if there's a way that I can add the total number of hours they can use to the…
-
Workflow Automation for a 2-week notice email
Hello All. I have a sheet that has staff name and their term date. I want Smartsheet to look at this sheet daily and send an email to HRC with details of staff whose term date is 14 days from now. to do that I originally configured trigger to two weeks before notification date and set my other two conditions but then…
-
Count weeks in a Cycle
I know there is a function for counting weeks based on the start of the year. Is it possible to count weeks from a specific start date, instead of from January 1? For example, I might have 12 weeks in a cycle of a project, and would like to show (on a dashboard) that we are in "week # of 12 weeks" in a specific cycle.…
-
Merged: Auto timestamp
This discussion has been merged.
-
Time stamp challenge
I use "the copy row" function to a new sheet workaround for a time stamp if a checkbox is checked. In my original file I use the VLOOKUP funktion to get date and time. So far that workaround is working. My problem is, that in my file where I collect all this "checked" rows, the modified date always changes (to actual date…
-
Notifications sending too early
Is there a way to set the time the notifications send? Our associates are getting notifications at 2 and 3 in the morning.
-
Issue with Syncing Smartsheets to Outlook
We're very excited to have discovered the feature which allows us to sync Smartsheets to Outlook. However, when we import the calendar, the events are loading as all day events (see calendar to the right). I'm guessing we have done our "time" column incorrectly, but aren't sure how to fix it. Thank you for your help!
