-
Weekly Email Automation
Hi there! I am trying to set up 2 weekly automatic emails. I have 57 active projects, each have there own project plan in sheets. I have a RAID log report containing all 57 projects that I have turned into a dynamic view. I want to notify the individual that has something on this log but not the whole team every Monday and…
-
Which template to choose?
My small civil engineering company is brand new to Smartsheet. I will be overseeing about 70+ projects spread out over 8 engineers in the company. I want to track the status of each project, and add milestones/tasks to each one along the way. Each project also has its own budget. I want to be able to track each project &…
-
WorkApp Admins
Just as Workspaces can have multiple Admins, can we make it possible for WorkApps to have multiple admins? It will make maintenance and adjustments easier to manage.
-
Deeper AI Analytics
Can you make AI smart enough to compare multiple row attachments and create subtasks, summaries and/or compare and contrast information within said attachments? Similar to ClickUp Ai. Would like to be able to compare documents for similarities to uncover gaps for projects or create tasks based off of meeting transcripts…
-
When Predecessor Completes Mark next task to In Progress
I am struggling finding a formula to mark the successor task "In Progress" when predecessor is "Complete" like can be done in MPP. I am encouraging my organization to move to SS with the automation, reporting, dashboard and automation capabilities, and away from MPPP so trying to replicate some of the items they utilize in…
-
How to populate valid resource rates from a source table, for each week of a project.
I have a Resource Table with… Resource ID Name DailyRate ValidFrom R01 Resource X $1,500 3/8/25 R01 Resource X $2,000 9/1/25 R01 Resource X $2,200 9/31/25 I also have a Week by Resource Table with… WeekID ResourceID WCDate ValidRatePerWeek W01 R01 3/2/25 auto-pop $1,500 W02 to W26 R01 All the dates for W02 to W26 auto-pop…
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if the…
-
Printing comments under relevant tasks
I've got a sheet set up with multiple tasks assigned to different people. When printing the sheet the comments are all listed at the bottom of the sheet rather than under the relevant tasks. Is there a setting that allows the comments to be printed under each task ?
-
New to Smartsheet and completely overwhelmed - how do I manage trials with multiple tasks?
This is what I would like to accomplish using Smartsheets but I am struggling to find the best way to go about it. Each year we get new vegetable varieties that we need to test in various locations at different times. I would like a tool that I can follow each variety up with a grower. The following data is added:…
-
Help on getting the SHIFT from a time
Hi, I m trying to extract the shift where and inspection is conducted. primary time source is CREATED DATE column, than I extracted the time using the formula " =TIME(RIGHT([Inspection Date]@row, 8))" however I can't figure the approach to get to the Shift if I am hoping a return of 1, 2 or 3 from: Shift 1 = 0600 - 1359…