-
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!
-
How do I find/calculate the available (latest) date from multiple rows WHERE there is a condition
Intent: Calculate date team member is available I have a resource planning sheet, which lists a number of activities (by row) for team members. Each row describes the team member, activity, the status, and the start and end date. How do I find the latest end date for each team member, where there activity is 'In Progress'?…
-
Date+days not calculating correctly
Hi all, I need to add 21 days to a date referenced in another cell. Ex: 10/15/23 When I use this formula: =DATE(YEAR([Projected Start Date]@row), MONTH([Projected Start Date]@row), (DAY([Projected Start Date]@row)) + 21) I receive an #INVALID VALUE If I hardcode the date into the formula (=DATE(2023, 10, 15)+21, I return…
