-
"Created By" column limitations?
Context: We have a Form that was created about 5 months ago for Tech Request Tickets for our company (all internal). Within our company, we all have Smartsheet accounts. We had an issue of auto-population within our form; we couldn't seem to get an email format when people were submitting requests, only the first name was…
-
Merged: Specific Column Selection in automations
This discussion has been merged.
-
Formulas referencing too many cells on source or destination sheet 👎
"Formulas are referencing too many cells on the source or destination sheet. To run this workflow, please reduce the amount of cells referenced by formulas." How do I figure out how many and what formulas are connected to the sheet causing this error? Neither the source nor destination sheets have the blue or black ▸in any…
-
How can i read activity log using c#.net through API...?
I need to restore a specific row which are deleted from the original sheet, and i am using API to achieve this with C#.NET. Our idea is to create new helper sheet using c#, which contains deleted rows in it, That has to get updated by reading data from activity log May i get any suggestions. Thank you in advance.
-
Error 1008...
Hi Everyone, Ive been trying to automate a couple of imports to our smartsheet. Long story short, it is a JS script that takes a xlsx file extract taa from it and exports it to smartsheets. TBH ive been working on this project on and off for at least 4 months. As of now, the latest error im getting is this: Error adding…
-
Generating a Document
I want to generate a document using DocuSign and I know with the fillable PDF you can use information gathered from form entries for the PDF document. My problem is that I cannot get DocuSign to pull in the email's from the contact lists columns. It is my understanding that this is a possibility but I just cannot get it to…
-
Using an IF formula for Parents, Children rows
Hi all, I'm currently trying to see if there's a formula that can be used to affect the parent row (row above the indented row) after a certain condition has been met within the children row (indented rows). Please see the image as a reference. In this example I've set up, I'm trying to figure out if there's a formula that…
-
Is there an automation/formula that allows a copied row to be updated?
I have created a master sheet for grant invoicing. We have 14 different institutions who received the grant and who will be submitting invoices to the master sheet. I have created a workflow for each institution so that when they submit to the master sheet, that row will be copied to a separate Smartsheet with just the…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
Merged: Enhancement Request: Logic and Helper Texts for Request Update Workflows
This discussion has been merged.
