Good evening We have forms we created where one of our form entries is the name of the project. When we create a new project in smartsheet how can we make it so that the project is automatically inclu…
Hi all what are the limitations of MS Project imports into smartsheets? the following is imported * task, start, end date * predecessors * completion % know of the following is not imported: * Base li…
Hello, My office recently created an Internal Communications Intake Form on Smartsheet. The problem is, the column marked Today's Date seems stuck on Feb. 20, 2019. How can I fix it so that it will ac…
I was wondering if there is a way to have subtasks with fields that are different from the main tasks? We would like to use card view but have subtasks depending on the project that will have differen…
Is it possible to block out certain dates with a date field in a form? For example, when the calendar comes up for March 2019, I don't want March 15 as an option. Is this possible?
Is there a way to alert the user when, for example, they check a box, but other conditions are not currently being met? I see I can send emails and Slacks and whatnot, but I just want something to app…
I am trying to set an IF function to the At Risk column. I would like it to flag if the end date is within 2days or if the % complete task is less than 80%. Can someone help me set that function up? T…
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metr…
I am using Symbols in my sheet for 'risk level' using the standard Red, Yellow & Green. I then have a report showing how many/what percentage of risk we have per risk status above. I have added the re…
i'm using the project tracking and rollup template set and trying to add all of the members of my team to the pulldown for 'assigned to'. i cannot seem to add more than 6 members, or the list automati…
I have a very simple sheet that has a column of numbers. Using a Sheet Summary formula such as =sum([column1]:[column1]) I get an answer, but it loses the number formatting - specifically the thousand…
