-
Grouping in Reports
I need to do something other than just group alphabetically or numerically by ascending or descending. I would like to be able to choose the order in which I see my "grouped" report. I feel like you can do it, you already sort of have it in the filtering set up in reports, you just have to assign a numbered system in which…
-
Smartsheet login issue
I recently addet a user to my workspace and sent him an invite link, by accident i send a second one shortly after. He opened the website using the first older link (i dont know if that is relevant), now if he logs in he gets the taskbar on the left but the rest is just gray. If he try´s to open the workspace it seems like…
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Sequential numbering not working (Project with WBS sheet)
Hi All, I am fairly new to Smartsheets, so please be kind :) I am creating a WBS with the Template the Smartsheets provides (Project with WBS sheet), but I am noticing that when I add new tasks between other already created tasks, the numbering goes all wrong. Also, Even if I add more tasks underneath, the numbering is not…
-
Data Mesh. How to pull multiple data points based on multiple selections into one cell
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
Move rows Automatically | Automation Workflows
Hi, I have 1 source sheet and 1 target sheet. Using Data Mesh/ Shuttle, I'm adding the records to the target sheet from the source. There are chance that few records in the source can be deleted later and such records are not to be retained in the target as well. So, I added a column formula in the target that checks if…
-
Leading zeros dropped on Python SDK add_rows
We are using the smartsheet-python-sdk to insert rows into SmartSheets. For almost two years we have had this script running with no issue, but in the last week, SmartSheets has started to trim the leading zeros on fields that are all numeric. Nothing has changed in our sheet or in our script. Are others having this issue?…
-
The sheets of the workspaces I own are deleted by themselves every day
Good morning, greetings. Since I renewed the license, the sheets of the workspaces I own are deleted by themselves every day, please how can I solve this problem?
-
Every time i want to make changes on my report it gives this pop up dont know what is happening