-
Stacked Bar Chart using Metrics and multiple data sets
Hello, I am struggling to gather data together from multiple data sets to represent as a stacked bar chart. I have large spreadsheets that use dropdown options for data I need such as customer journey and impact rating (high, medium, low) there is a lot of other data in these sheets as well and they are over the 100,000…
-
How to form a =COUNTIF Column in reference to an already formulated 'Unique Column'
To further explain in reference to this community post. here, https://community.smartsheet.com/discussion/57396/generate-list-of-unique-values-index-distinct-vlookup/p1 I've successfully been able to apply the formulas suggested from that post and build out a column of unique names. Now in a separate column I'd like to be…
-
Is it possible to count the number of entries in a column for the current work week, and quarter?
Is it possible to count the number of badge IDs in a column for the current work week, and a quarter? I need to track the progress of a weekly target that resets every Friday. Currently, I can not get the CWs (blue) to align this is my starting point for all of our contract workers. Here is one of my sheets created that we…
-
Return ALL ID#s from another sheet if other Sheet equals "specific name"
Hello Everyone, I am brand new to using smart sheets. I have a lot of experience us PBI but not as familiar with the smartsheet formula writing. I have a completely blank sheet and also a roster sheet with ID numbers and location names. What I want to do is to return ALL ID numbers from the roster sheet row by row in one…
-
IF, AND formula for checkbox
Hello, I'm trying to make a formula for a checkbox column where if the column titled "Expected result" is positive, but the "Results" column is negative, then the checkbox will be filled (and vice versa if expected is negative and result is positive). However, I cannot say if the expected result column and results column…
-
Formula Criteria - IS ANY OF based on Multi-Select Dropdown
Hey, So I'm going to guess that the answer is no, but I'm going to hope the answer is yes. We have a board that is used to help track hot or critical inbound items. The goal is to retrieve dates from our, lets call them 'Build Trackers', based on a series of criteria in order to help inform the priority and urgency of…
-
% Allocation Formula for Assigned To column
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s…
-
Can it be done? Round "-" IF +
I can do this with a metic sheet but I would like to try and do it all in 1 formula. NOT sure it can be done! I currently have a formula that gives me a number. Let's call it 17.35 I then round the number to split them up into 2 different cells Row 1 = 17.35 Row 2 =ROUND([Column1]1, 0) Answer is 17 (In Excel I use TRUNC)…
-
Basic checkbox counting to apply status option to Parent rows only
I am unable to get the output to say "Not Started" in the Status column for the formula I am using. What is missing? Also, is there a way to reference "Done" part of the Children of the parent without specifying the exact row number (e.g. "Done2") in the formula? Formula example that needs fixing below:…
-
Using Countif in place of Autonumber - formatting question!
I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request Type]@row, {Ticket Assignment}, 2, false) + (COUNTIFS([Request Type]$1:[Request…
