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 wit…
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 th…
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 …
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…
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 workin…
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 ri…
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…
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 Sta…