-
Copying row from one sheet to another
Hello, I am trying to copy a row from someone else's intake sheet into one of my intake sheet using a templated automation. However, when I try to add the automation to the other user's sheet I can't find my sheet. Do both Intake sheets need to be in the same workspace for this type of automation to work?
-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
-
Reasons for error code 1008 in webhook subscription request
Hi, Zapier Integrations team here. We are experiencing users reporting being unable to set up a webhook subscription to Smartsheet when a POST request is made to https://api.smartsheet.com/2.0/webhooks Response received { "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field 'name'…
-
Formula to Pull In the Sheetname to A Cell?
Hi all. Is there a formula or a way to pull in the name of the open sheet, into a cell on that sheet? Ideally I was thinking something like =sheetname but that's not an available formula.
-
range checking & flags
Hi, I'm trying to leverage a formula to check if the employee ID is listed on another sheet. Sheet 1 (sanity check): This is where I want the formula to live. On sheet 1, if the employee ID on the row is not listed anywhere on Sheet 2's Employee ID column (range), then turn the flag on. If the employee ID on the row is…
-
Deeper AI Analytics
Can you make AI smart enough to compare multiple row attachments and create subtasks, summaries and/or compare and contrast information within said attachments? Similar to ClickUp Ai. Would like to be able to compare documents for similarities to uncover gaps for projects or create tasks based off of meeting transcripts…
-
Can a sheet-only Viewer see Workspace members or other collaborators on the same sheet?
Hi everyone, Quick question about sharing permissions in Smartsheet: If I share a specific sheet only (not the entire workspace) with someone as a Viewer, will they be able to: See the list of people who have access to the workspace itself? See the names of other people who are shared on that same sheet (the collaborators…
-
Pull data from a row
I'd like to pull data from a Smartsheet row, having designated specific columns, and put it into a document that can be printed.
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
Copying column to another sheet
Hi, I have a sheet that includes a calculation to update the value in a specific column in real time. We'd like to track the values over time (monthly) and are looking to automate the process of copying the column and pasting it to another sheet, so we'd be able to create a line graph that shows changes over time. I am…