-
calendar and linked registrations
Has anybody used SmartSheet to mass distribute a calendar with multiple events shown and connected independent links so people can select and register for each of the separate events?
-
Multiple Installation Dates to show on Calendar
Hi, I'm trying to schedule 2 dates form the same line into a calendar. For example. Each time we sell a job, the job has a Part A installation, and a Part B installation. With this the line would have Part A Date, Duration and a installer. Same with Part B. The Installer is conditional formatted as a colour to show up in…
-
Reminder Escalation
Hello there! I set a reminder in the grid view to inform the project owners of the 4 teams that they know before the start date, if they don't change the status to "Complete", they will be reminded every 3 days, if they change, it will no longer Remind. Now, I want to set up an upgrade reminder based on the previous…
-
Trouble with Calendar App Group Data
Hi! I am having trouble with the Group Data By function and using the Custom Category List Order. Some columns that I sort by allow me to choose custom colors while others do not. Is there a reason why some columns allow sorting by color and others do not? How can I identify which columns will allow sorting by color?…
-
Must start / must end date restrictions
Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Project Manager for projects within the administration environment I do have a desperate need Smart Sheet does not cover. It…
-
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?
