-
Copy/Paste Not Working Today
Today I copied data from and Excel spreadsheet and tried copying it to corresponding cells in a Smartsheet grid and the paste function didn't work - no data was pasted. I've copied and pasted data into sheets many times in the past and have never encountered this problem until today. Is anyone else having this issue? Can…
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
Data Import in bulk from Excel
Hi, Can anyone suggest how to import the data in bulk from excel, the number of data is around 37000. I can see that we have limit upto 5000, On Smartsheet I have to weekly import the data for the production. Copy and pasting is also not working as we have limit of 500 data at a time.
-
CSV Export
I don't see CSV as an export file format option. Does anyone know if this is possible or coming anytime soon? Thanks, /mark
-
Finding Duplicates
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
Automated export and Automatic upload
Each time a row is added (which is requiring an approval) i need the sheet to export the new data, to either an excel spreadsheet or google doc and upload to a secure site. The other option would be to do this based on frequency like nightly, but I guess the real question for me, and yes I am both new and green here, can…
-
Convert Smart or Curly Quotes to Straight
We use a Smart Sheet to track new product development requests from our account mangers through engineering. At the end of the process, we need to transfer the information into NetSuite, our ERP system. The problem is that the data gets copied in from a variety of sources and sometimes includes curly quotes instead of the…
-
Scheduled export of sheets
Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…
-
Read receipt
Good Morning, Is there a way that if I @someone on my smartsheet and it sends them an email that I can be notified when they click the link and look at the smartsheet?
