-
Copy Problem Excel To Smartsheet
Hi there ; i can not copy any cell excel to smartsheet , is there anybody has the same problem today too ? or ho can i solve ?
-
Large criterion name
Hello, I'm trying to make a formula to count the number of jobs by builder for the month of January to go into my sheet summary. I managed to get the formula working for January however when i copied and pasted the formula and changed the name of the builder i got #invalid operation. The working formula is as follows,…
-
Nested If SmartSheet Formula For Symbols (R, G, Y)
=IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow"))) i.e. =IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))
-
Maximum Downloads
Has anyone ever encountered this issue? We sent out a single line from SmartSheet that held four attachments to approximately 180 individuals to download. For most it worked wonderfully. Now, we're getting this message: "Unable to download file. The download URL has exceeded the maximum number of uses." Of course, I now…
-
#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…