-
Resource Forecasting
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 multiple individuals does not work for me. * Each individual has default work hours. E.g. 8 hrs. It can be modified if needed…
-
Time Lapse Calculation
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 task is marked completed under the status column or checked done, stop calculating the days. Thank you for your help.
-
Repeat Columns on Charts
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 want only one column for A.
-
How to get attachment id.
I am using c# to try get the attachment id of an attachment in a certain row in order to download the attachment. How can I achieve this?
-
Search Bar Question
Is there a way to add a Smartsheet search bar to a web site, linked to my smartsheet?
-
Sorting by percent complete
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 used to appear at the top now they appear at the bottom. Without having to enter a 0 in every sheet that has not started the…
-
Dashboard and Metrics
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 data that shows the project type, approval status, departments, etc...
-
Automated numbering of parent items and tasks
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 the primary column. If I now add a task in the middle of the list, I theoretically need to change all numbers afterwards...…
-
Creating templates with Automation
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 creating a sheet template. Does anyone know! I hope this is a yes! HELP ! Thank you!
-
Need a Work Around Please
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 and I, have superiors who want me to create a report showing the total orders scheduled by day of the week and then I have…
