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.
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, oth…
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 …
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…
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 ma…
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…
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 …
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 suc…
