-
Hiring for a senior project coordinator position - Kansas City
Hello community! I am hiring a senior project coordinator based in Kansas City. I work for WellSky, a software and services provider in the healthcare industry. This junior position requires a bachelor's degree and two years of experience and would work with me in our marketing organization. We will support the efforts of…
-
Different Settings in Same Project Sheet
Is it possible, by formula or settings to have within the same project sheet, some tasks & sub-tasks that will need to use a 7-day work week (no weekends, no holidays) and also some tasks (and sub tasks) that will need to utilize the 5-day work week and holidays? To clarify, all of this is in the same sheet for a single…
-
Move rows Automatically | Automation Workflows
Hi, I have 1 source sheet and 1 target sheet. Using Data Mesh/ Shuttle, I'm adding the records to the target sheet from the source. There are chance that few records in the source can be deleted later and such records are not to be retained in the target as well. So, I added a column formula in the target that checks if…
-
Box link in Smartsheet Form
Hello, We are consolidating document management into Box, and as part of that we want to avoid users attaching documents directly into Smartsheet. We can turn off uploading to Smartsheet on our Enterprise account, but before we do that I need to make sure that we have an alternate way for users of forms to include…
-
Archiving Project in Control Center Should Also Remove Project from Portfolio WorkApps
When you archive a project in control center, it does not remove the project from Portfolio WorkApps. This leads to confusion for project owners and others shared to the project when they still see their archived projects within WorkApps. The only way to remove a project from WorkApps is to delete the project from control…
-
Team Assignment Report Help
Hello All, longtime user of Smartsheets for work - first time poster seeking help. I am search for a solution in creating a report to show all of the assigned tasks from a Smartsheet that outlines all of the Classes our Org is holding for Staff this year as sorted by assigned Training Staff. Those Training Staff are…
-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
Seeking advice on template sets.
I am new to Smartsheet and am hoping to get some advice on which template set would be best. My biggest concern is meeting the executive's requests. The executives are looking for a dashboard that shows an overview of the 20-25 projects that we will be running soon. Executives would like the dashboard to include project…
-
How can I write a formula to pull data based on dynamic columns?
Hi all, I'm trying to write a formula that will pull row information based on dynamic Columns. My goal is to understand the difference in hours worked between last week and the week before. I would like to be able to flag if a Person has not updated hours in a week. I have a 'raw data' sheet which has team member names in…
-
Calculate start date based off of end date
Hi All, Can someone help me with a formula? I've searched the community and haven't been able to find an answer. I already have a formula in place to calculate the end date based off of the start date and duration of project. However, if I have an already defined end date I'd like to calculate the start date based off of…