-
Why is the mobile app showing me a different form?
Hello everyone, I hope you are having a good Sunday afternoon, I created a form that works very well on computer. On the other hand, when I open the same form on the smartsheet application for a mobile phone, it seems that it does not take into account certain logic that I have programmed. Before opening a ticket with the…
-
Normalized Rank Formula
Hello - I am trying to recreate the formula below in my sheet. However, instead of using tabs in excel (e.g. 'Project Type Weight'!B:B), I am tagging the row and dragging the number of rows down (row1:row100). I am getting either an unparseable or invalid operation error. Can someone please help? 🤣 Excel Formula:…
-
Automatic roll up of the same Field?
I have an internally corrupted data base. Our people have been inputting the wrong/random ID numbers for the same Model #. I exported some of our data from our database into a Smartsheet to see if I could sort them. Below is snip of a 20,000 row sheet that I want to organize by model number and have all the same Model #'s…
-
Updating rows with multi_contact cell?
Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact column (with multi_contact enabled). I'm getting the error that I need to use…
-
Premium Feature High Prices / Locking out Small Businesses
Hello, Is anyone else disappointed in the pricing and the lack of availability of the Smartsheet Addons/Premium Features? The features of these premium addons are pretty badass and would be useful. I feel like I would use dynamic reporting (especially if they had date filters) quite a bit. Along with this, I use a lot of…
-
Having Issue with "COUNTIF" returns "0"
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for everything. I have tried to change the name to execute but that doesn't work. can you please…
-
Cursor Bug when Referencing other Sheets in a Formula
Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…
-
Form: Disparities between English and French logic
Hello everyone! Before opening a ticket with the Smartsheet support, I thought it was worth it that I ask my question here. I think I have a problem with the french version but maybie I miss something. The logic section is suppose to show me the choices below, but in french because of our liscense. The problem is that the…
-
Activity Log
Is there a way to generate a report from the activity log? What I want to do is to be able to quantify actions being taken within a time frame (i.e.: one month of time). For example, I would like to be able to track how many lines were added to our master sheet - and how many were removed. I would also like to be able to…
-
Can you automate attachment exporting?
We can export sheet data automatically using tools like Power Query but is there a way to get attachments out of smartsheet and into our server? Or is this something that needs to be done by hand? Thanks