-
Nested IF Error - Incorrect Argument
Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar column with ranges based on a Status % column for a Project Tracker. Here is what I have: =IF([Status %]88 = 0, "Empty",…
-
SUMIF from one or more reference sheets
Hello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Category" column. Would I use VLOOKUP alongside SUMIF? Attached give you an idea of the breakdown. Thanks,
-
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…
