-
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…
-
if and statement
Hi, I am currently facing a situation were one entity has multiple ID and country.Hence formula for region should be based on first Entity and then on Country..i think If AND formula has help like we do in excel. Can someone help me with an example how to perform it Thanks
-
Creating Dashboards
I am new to creating dashboards in SS. I have gone through the SS online tutorials and not finding the details I need. I need to create reports using formulas and what I have tried I have not been successful. Does anyone have suggestions on other materials to review?
-
return fiscal quarter from auto generated date column
Hi, this formula returns a blank - what is wrong? =IF(OR(MONTH([Created Date]9) = 8, MONTH([Created Date]9) = 9, MONTH([Created Date]9) = 10), "Q1FY " + YEAR([Created Date]9), IF(OR(MONTH([Created Date]9) = 11, MONTH([Created Date]9) = 12, MONTH([Created Date]9) = 1), "Q2FY " + YEAR([Created Date]9), IF(OR(MONTH([Created…
-
Index and Match
Hi , How to use Index and Match function in SS.Please advise with an example
