-
#INVALID VALUE error with collect/index/match/small function
Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values from a source sheet. The frequency of the part within the source sheet is then…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
-
Excluding duplicates from formula
Hi there! Had a wonderful talk with a Pro Support the other day, and he helped me write an incredible formula for counting "Left to Sell" value on sales items our team is selling. However, I noticed after the fact that it is counting each item as 1 sale, and there may be some sales that cover multiple items but should only…
-
How to edit a workspace
I have been given "Editor-cannot share" permissions by the owner of a workspace but I am unable to make any edits in the shared workspace. When I try to double click on an empty cell, I do not get to edit it. Please advise.
-
Remove name from Automated workflow I created
How do I remove my name from I automated workflow I created and add someone else name. See image attached?
-
Copy and move row workflow disabled by smartsheet
My copy/move row workflows (that previously worked) were disabled yesterday. I now have an error that says "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet." Anyone else have this issue? If this is new functionality, then the workflow will only work…
-
Resizing Sight To Eliminate Blank Space
Hello, I'm having an issue with a sight where there is blank space at the bottom of the sight which will not go away. This looks ok when using the sight in smartsheet, but when it's embedded in another application using an iframe, it leaves some space. That means the height of the frame has to be large enough to span the…
-
Smartsheet: Customers intermittently being logged out with a session timeout.
Hello all, Starting November 23rd around 9:30pm Pacific Time, we began receiving reports that customers were being unexpectedly logged out. More details can be found here: https://status.smartsheet.com/incidents/7qrz2djs5lgs We have narrowed down the recurring session logout issue to only impact customers who use Cisco…
-
Smartsheet - Logging me out / Closing while working
Smartsheet is logging me out / closing while I'm working on it. I have submitted a support ticket, but have not received any response or feedback. Is anyone else experiencing this issue? It seems similar to the issue that happened on 11/5/21.
-
Using Index with Collect to Copy information from one sheet to another sheet for an entire column
Hello, I have 2 existing SmartSheets: Sheet 1: A Master sheet with 2 columns: Sheet 2: Another Sheet where only the "Die Name" where "Is Die 1 New?" = "true" is captured. I have tried the following formula under row 1 under "Unique Die Name" in the 2nd sheet: =INDEX(COLLECT({Die Name}, {Is Die 1 New?}, "true"), 1) This…
