-
Share sheet as a copy - Consolidation
Hello everyone, Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators. The idea is : * I build a main spreadsheet, and I want multiple collaborators to fill this sheet individually * I want to keep track of all the status of certain indicators for each…
-
Conditional Formatting not working?
Hi, all. As the attached shows, I have a rule to turn the whole row a color if the Task Name contains "S18 D1". But, only one row is colored? Am I doing something wrong? Thanks!
-
If x Then x in columns
Hello, Using drop down choices in columns, is there a way to take a column with a certain data value, & then in the following column, only certain choices appear in the drop down choices found there, out of many? Example: Entire set of Data consists of: A,B,C,1,2,3 Column 1: If you select A, only options 1 & 2 can be…
-
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…