-
Prioritization and Forced Rank
Hi all! I'm creating an intake form to help business leaders prioritize and force rank of dependencies. Example: Main project: Develop a recyclable lid for water bottles Owner: Barney Rubble I'd like to send an update request to Barney asking him to tell me what departments he is depending on to get his project done. For…
-
Netwokdays count since an approval request was issued.
Hi, I am using an "Issued" date column as a trigger to send approval requests. I am trying to capture the number of days since the request was issued in the "Age" column, where I have this formula: =NETWORKDAYS(Today(),[Issued]13,[holidays]) The result i am getting is Unparseable. Help please!
-
Charts - comparative data colors
I am having an issue with charts and my column colors. I am getting all the same color columns. I asked about this in the webinar last week and received this answer: "Colors are going to denote different comparative values (what's labeled in your legend). If you're not comparing more that one data set, you won't have…
-
Chart in Smartsheet
Hi, I am trying to create a new chart in my sheet, but the chart type is not available when I select 4 datas. There is no problem when I select 3 datas, well I don't understand why I can't create my chart with one more data. Could you help me please
-
% Complete Based on Amount of Tasks, Not Time
Hi, New to Smartsheet, and wondering if there is a way to have the % complete cell calculated by the number of 'child' tasks only, rather than basing it on the amount of time each task takes to complete. For example, if I had 5 'child' tasks below 1 parent task, I want each one to be weighted equally at 20%, regardless of…
-
Date Dependency in a Form
Hello, I have a form setup for vacation requests and tracking purposes. In the form the requestor has to input todays date, which automatically defualts to today's date, but we're having issues with the start and end dates. I would like default date to be dependent and automatically to at least update to the start date to…
-
"No Filter" view
After viewing a filter a user selects "No Filter" to return to the full sheet. Whenever I return to the "No Filter" view, the view is not what it was before I selected a filter. For example, I have a specific section expanded and all others collapsed. I select a filter, then go back to "No Filter" and all of my sections…
-
Nesting MIN and IF functions
Hi, guys! I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I would like to calculate the due date of the next report which has not already been submitted. To find the…
-
Formula Date Remaining Static
I have aprroximately 30 sheets related to a corporate merger. In every sheet I have a formula that populates today's date +1 whenever a status column value = Complete. The formula is: =IF(Status2 = "Complete", TODAY(1)) This then triggers a reminder to a supervisor to review the task and approve its completion. So, the…
-
one task through multiple calendars
I'll try to explain what I'd like to accomplish. My task name has sub-tasks for example "custom","boxcut", "assemble","finish" that populate calendars. On the calendars they show all of the "custom tasks" for all main jobs. How would I setup a calendar to show all the sub-tasks for just the selected task. Such as the…
