-
Avoiding a massive nested IF formula - checkboxes?
Hi all, I have 5 check boxes and based on these being ticked or unticked i want to display something in another cell. It is essentially a decision tree that simply i want to work as follows: If Group 2 is not ticked (or nothing ticked) = Group 1 If Group 2 is ticked but 3, 4, 5 & Close are not = Group 2 If Groups 2 & 3 are…
-
Time Formats - Number formats - Rethinking the UX and function
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of common things. So as to have them available and globally modifiable across workspaces. Use…
-
What's an effective way I can plan my resource's hours for the next recurring 12 weeks?
Right now, my management asks PM's to predict how many hours their resources will be spending on a given task (tasks = rows) per week (1 week period = 1 column)? What's a possible more efficient way to do this? At the moment, we have to manually input new columns after the initial 12 week period is up. It's a time…
-
Creating a User Experience "Nuggets" Database
Hi folks, This article about a SmartSheet competitor, Airtable, has been making the rounds in my little universe of technology products researchers. https://medium.com/@WeWorkUX/the-atomic-unit-of-research-insight-17d619583ba As user researchers, our job is to understand users of our products - their unmet needs, current…
-
How to work around this Cirular Reference Error?
Hi everyone! I am working on an Inventory sheet for my business and it is not allowing me to do what I need, IE(CircularReference Error). I have a [Starting Inventory] set at 20 in my 'Master Inventory' Sheet. Then I have 2 Forms that are filling in the [Inventory IN] and [Inventory OUT] as my team re-stocks and takes off…
-
Request Tracker Form
Hello, I have a couple of questions. I am looking for the formula in the "estimated days to completion" column. It doesn't appear to be included (Screenshot 1). Also, how do I reset the request ID numbering to start at 0 again (Screenshot 2) ? I tried deleting the rows and that seemed to cause all sorts of problems. Thanks…
-
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…
-
Automatic report creation with custom template
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API or integration with any other platform that would make this possible? Any help is much…
-
Is there a way to deal with "maybe situations" or varying predecessors?
Hi SmartSheet community! This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but only on an as-needed basis dependent on results. For example, we anticipate product A will need 4…
-
How do you expand the height of a row?
How do you expand the height of a row?
