Here's what I want to be able to do for resource management. Is there a workaround to accomplish this? * Assign individual resources (they are not licensed users) to a team\group. Assigning tasks to m…
Hello, I checked the community threads and cannot find a formula that would work. I need help with a formula to calculate the number work days elapsed from the project start date and today. If the tas…
Hi, When I try to use the graph function on the dashboard I am having repeat values in the columns. Is there any way to get the columns to combine and the figures to add? For example... in the picture…
I originally created a report that showed all the sheets I was assigned to a specific task ans sorted by percent complete and then by sheet name. The sheets that had nothing in the percent complete us…
I'm trying to figure out the best way to pull only proposed or active projects from our All PMO project lists and creating a dashboard. Based on the only active or proposed projects ....I need to pull…
Hello Community, I have imported a project list of about 250 tasks from excel into smartsheet, divided into different parent topics. I've numbered these into 3 levels (like: 01.1.1.) manually within t…
Hey All, I am creating a template including automations for reminders. My goal is to make this a template, but now im unsure that all my automations will be stored in the template or if its just creat…
I have an Admin who doesn't wish to share the sheet with me so I can add a column to covert the date in the date column to a Weekday, Is there a way to do this on a separate sheet? Our, Both the Admin…
Hello! I am very new to smartsheet - lots to learn! I have a dashboard that has a metrics table at the top which is from a report. The report is a simple table which uses =SUM equations to get the yea…
Hi Smartsheet Community, I was working on a dashboard and clicked the "wider canvas." When I was about to return it to its original view, the wide option was no longer available. Can you please help m…
Hi all, long time listener and first-time caller, I was unable to physically select the "best practices" category, so this goes here. I work for a home builder, and we have a specification grid we uti…