-
Trigger notifications based on dates previously input
Hi all, Trying to build 2 spreadsheets that need to communicate with each other at this level: One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, test required, etc. The other (second) spreadsheet will be a record of materials booked in. Will it be possible that, by…
-
Project Management: Weekly capture of actuals against planned hours
Many thanks in advance! We have a team of project associates that are asisgned to a number of tasks on a project in a smartsheet. I want to be able to send a timesheet to each resource at the end of every week. On the timesheet I would like to display the task for the week and ask for actual hours to be entered. These…
-
Allocated Time % versus Duration
Can anyone tell me the correlation between Allocated Time % versus task duration? If I estimate that a task will take 2 days (16 working hours) to complete but then assign someone to it that only can work on it 50% of the time, why will the system automatically create a start and end dates that are consecutive days? Since…
-
Auto/number - date on particular cell, not whole row
I'm trying to find a way how to populate a datestamp in a cell based on the last change from an another cell in a particular column fe: Row 1 - column A: dropdown (Start, pending, stop) Row 1 - Column B: I want the date when Status changed on column A Auto/number - date: works, but it looks at every cell on that row, i…
-
Calendar
Has anyone used Calendar to track employee schedules? If so, how did you do that?
-
Add Vacation to Individual Project for Individual Employee
I want to denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in smartsheet?
-
Calendar Function out by 1 day
Hi all Has anyone experienced the following. When using a form and clicking on a date field I am presented with a Calendar. If I chose a day from the 29th September forwards the day captured is set to one day earlier i.e. if I select September 30th, the day captured is 29/09
-
Simple team-member tracking calendar
Members of our department are allowed to work remotely two days each week. We want to set up a calendar where we can show which days each of us will be out of the office. In most cases, each of us will have the same two days each week, but we can change if needed. I created a new document and went into the Calendar view,…
-
How to PDF print multiple months in the Calendar APP?
Self explanatory hopefully from the title. I wanted to PDF print a full calendar year from the PDF print function in the calendar app. Unsure of how to do this as PDF print function only brings me to the view of current month in the App Thanks
-
Receivable Over View
Dear all, Our current receivable has many terms such as advance payments / 30-45-60-120 days deferred. We are maintaining it in an excel sheet but I am afraid some receivable might be missed. What I am looking for is a sheet where I enter the customer invoice value and by when what percentage of that value will I receive.…
