-
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
-
Is there a way to recover a deleted user?
Someone was termed who shouldn't have been termed and their account was deleted. Is there a way to recover a list of all the smartsheets that were shared with her or recover the smartsheets shared to her? Her owned sheets are fine as they were transferred to me but she needs access to all of the sheets that were shared to…