-
COUNTIFS and with 2 different values in same column?
Hi there, I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete". I've been trying different ways to organize COUNTIFS to solve the problem, but I'm getting either "0" or #Unparse as a result. The most straightforward formula I've…
-
Formula to count instances of a word
I have a sheet that is referencing another sheet to provide counts on instances of certain values in different columns. What I'm stuck on is counting how many times a single word is used if other text is in the same cell. For example if I have a column call Fruit and I want to know how many cells contain the word "apple"…
-
Alert Rules
Is it possible when more than one row having same value( duplicate row is submitted) an alert message goes to the user that row already exist something like this..?
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Sorting a sheet when opened
Wondering if there is a way to sort rows of a sheet on open. Otherwise you have to set this up manually each time. If this is a smart sheet you would think it would be able to do this.
-
Combining AND with OR
From a logical perspective, I'm trying to write a formula that says the following - If the (Issue Type = 'BUG') AND the( Status = 1 of 5 possible values), then the cell value should be a red ball, otherwise, the cell value should be green. Regardless of what I try to type, I'm either getting #UNPARSEABLE or #INCORRECT…
-
Line Break as Delimiter in JOIN(CHILDREN()) Formula
1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this? 2. In Addition it would be nice to have "Primary Column" as prefix before the respective contents. Example Values for Primary Columns for two rows: Child 1, Child2 Value for relevant text cell of child 1: - lorem…
-
Help with IF / Then, or something like it
Hi Everyone, New to smartsheet and need some help. I'm trying to calculate a date in the future, only when the manager approval column is Approved. I've figured out the date formula, thanks to another discussion, but I'm unsure how to incorporate that into a nested IF, or if that's even what I need to do here. So have a…
-
Should I use a Report or a formula?
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what would I need to do? Could I use a report or a formula.
-
Cross-Sheet Formulas
Hi! I am trying to reference another sheet in a SUMIF. But I get "#UNPARSEABLE" I want to sum contribution $ in Column 2 if the vendor name is 9X. This info is in Sheet2. I am referencing it in Sheet1 Here is the formula : =SUMIF({VEND},"=9X",[{DSU}]) I have tried the formula =SUMIF({VEND},"9X",[{DSU}]) And…
