-
Cannot turn off "Send as Attachment" in a sheet
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
-
Importing Excel into existing sheet
i saw a post 12/9/19 about importing data, but wanted to see if mine can be done. excell file the is about 100 columns wide, 600-800 rows. Right now i am copying 50 columns, 500 rows at a time, till all are imported. if i import a new sheet, it creats a now sheet. I tried to do a formula pulling in the data, but, when i…
-
Import Excel Data into Existing Sheet
How can a large amount of excel data be added to an existing sheet? Copy and pasting is difficult because there are over 100 columns and over 12000 rows
-
İmported data to existing smartsheet and adding new rows
Hello there, I have been searching for a solution however so far could not found a working answer. I have two files which have same, identical columns. Call them X and Y files, these are imported excel files to the smartsheets. X have 50 columns, Y have same 50 columns and 2 more columns which have formulations. X will…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Approval Workflow: Record Name of Person Who Approved
When a approval request goes to multiple people, is there a way to record into a column the person who did the approval (e.g. Approved By column). I can see out who did the approval by reviewing the 'View Cell History' on the column that has the approval status; however, I would like to put the Approver name into a field…
-
Control Center issue with cell links on summary sheet
I have an SCC blueprint with two summary sheets. We have several metadata fields, two of which are set up as cell links in the blueprint, the job number and job name. That way, if the job number or name is updated on the intake sheet, it automatically updates on the project metadata sheet, which updates the summary sheets.…
-
COUNTIFS formula across sheets
Hi all I've been using Sheet Summary's to calculate some data which seems to work quite well. For instance this is an example of a Summary that is working fine. (Its an ISO27001 audit tracker sheet) =COUNTIFS(Finding:Finding, "Opportunity for Improvement", Status:Status, <>"COMPLETE", [Agreed closure date]:[Agreed closure…
-
Inquiry on Smartsheet API update Requirements by this June 3rd.
As per the mail sent by Smartsheet team (June 3rd Deprecation), we verified that below API end points were not the part of the provided deprecated APIs. But cross verifying again, please help us to verify the impact of the below end points. a.Get Sheet – GET /sheets/{sheetId} b.Rename Sheet- PUT /sheets/{sheetId} c.Copy…
-
Automation Infinite Loop Error
Hello, I created an automation so that my Status column automatically changes when my % Complete column changes. Basically, the automations are the following: If % Complete = 0% then Status = Not Started If % Complete > 1% and <99% then Status = In Progress If % Complete = 100% then Status = Complete My automation runs…