-
Using Join with Logic
Is there a way in Smartsheet to combine the data in the rows below AND include the Column Headers AND exclude the "No Impact" Status? The end result should look something like this:
-
COUNTIF HELP W/BLANK CELLS
I am trying to count the number of employees that have access to work remotely and have not been furloughed or laid off. The columns I'm looking at are: MODIFIED STATUS & TELECOMMUTER. The values in Modified Status are: Furlough, Separated, Reduced Salary, Reduced Hours & Other. The values in Telecommuter are Permanent &…
-
Can't update permissions on a WorkSpace.
I've created three different WorkSpaces and have a core group I shared them with. In each Workspace is a set of sheets we use as a template for our new projects. I need for that core group to be able to right click on the set of sheets and copy as new in that WorkSpace. I figured out that they need to have Admin level…
-
Index/Match? Not sure best function for my needs
Hello, I have a very extensive sales tracker that I use to log charges and calculate the sales rep's commissions based on those charges. The commission percentages change depending on a variety of scenarios, so I created four columns with separate formulas for each scenario. I need the commission column to auto-populate…
-
IF and HAS and OR formula combined (or alternative)
Formula wizards! Can you help me with this one? I have a column for Primary Team (single select) and a column for Secondary Teams (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X", is either primary or secondary. Report parameters won't let me do this (because I also…
-
Help with Formula for Data from 2 Columns
Help! Trying to display on dashboard specific date from two columns. The Internal / External Column has two drop down options namely Internal and External The Tier Column has six drop down options namely Office of CEO, HRC, Tier 1, Tier 2, Tier 3 and Tier 4 I can't get the formula to work that will show for example how…
-
Working to pull data in from four sheets to a master rollup sheet and keep getting an error
#incorrect argument set =COUNTIFS({XXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXX Liquid Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXX Assigned to}, Primary7, {Status}, <>"Complete") + COUNTIFS({XXXXXX Product Range 2}, Primary7, {Status}, <>"Complete") I'm using a Smartsheet…
-
Formula for COUNTIF
We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning). We also have another column titled quarantined and the drop down options are yes and no. This…
-
AverageIf Dropdown (Multi-Select) cell contains an attribute/value
Hi Smartsheet Community, thanks in advance for all your help. I've been able to learn so much from the help you provide to others. I have two sheets I am working with for this experiment: A master project list, with unique projects aligned to an objective and the option for different key result attributes (Drop down…
-
Formulas for visual symbols
Are there any formulas specific to visual symbols to simplify summary data for parent rows? I have a RYGB status for activities within a project and would like to be able to summarise the 'worst' status in the parent rows. For example, if three activities are green (on target) and one is yellow (slight delay) then the…