-
Esign w/o DocuSign Automatic Workflow
I am building an onboarding WorkApp for my company. DocuSign, unfortunately, only allows 100 documents to be sent out in a single year, even on the business pro tier and is the only integration directly used with SmartSheet for e-signing. As I need to send out hundreds, potentially thousands of e-sign documents in a single…
-
Creating an inventory
I have one sheet that is completed via a form. In the column Summer Shirt Issued, there are multiple options that must be selected. 2, women, X-Small. This indicated the number of shirts issued, the cut, and the size. I then want to reference this to my Current Women's Uniform Inventory sheet to deduct from the total…
-
calcular el porcentaje planificado de un grupo de tareas o de todo el proyecto
Hola. ¿Alguien sabe cómo se puede calcular el porcentaje planificado de un grupo de tareas o de todo el proyecto? Hice una formula para calcular el planificado de acuerdo al start y end date, pero a nivel agregado no funciona. Muchas gracias
-
IFERROR with Index / Match from 3 sheets.
Hi All, Trying to search value from 3 sheets and using IFERROR with Index / Match and am getting Incorrect Argument error. =IFERROR(IFERROR(IFERROR(INDEX({Project Intake Project Name}, MATCH([Project ID]@row, {Project Intake Project ID}, 0))), INDEX({Completed Project Name}, MATCH([Project ID]@row, {Completed Project ID},…
-
Compare two columns and return a yes or no
I have two columns on one sheet that I want to compare. If the value in Column A matches any value in Column B, I want a yes to be returned in Column C. I've played with the formula for over an hour and can't get it right. =IF(CONTAINS([RDS Serial #]@row, [Serial Number]:[Serial Number]), "YES", "NO")
-
How do I structure formulas so that I receive a specific count back regarding Task Status?
The Smartsheet above is referenced by multiple members of my organization, but I'd like to simplify some of the information for the members who only want to know specific metrics. I've obscured information that could be considered confidential. I'd like to write formulas that report back the following information: 1. The…
-
Beware of "Input column index X is different from the first input column index X"
If you try to create columns in one bulk request, do not give each column its own unique index. All the columns need one common index (example: 1), which is the starting point (from left to right) at which the entire column set will be created. If you try to give each column its own numeric index (1, 2, 3) in the request…
-
Help with IF formula - 3 options to return
Hello Smartsheet Community, I'm struggling with something that I guess should be a very simple formula. I need to assign one of 3 values to the row based on the following rules: If Cutoff Date > Event Date, return "Pre-" If Cutoff Date < Event Date AND Weeks Post Cutoff Date </=8, return "Post1" If Cutoff Date < Event Date…
-
Hey, I am new here! reaching out for some help!
I've configured Smartsheet to trigger an email notification upon form submission. Subsequently, the email forwards the request to Zendesk, resulting in Zendesk creating a ticket with the Smartsheet owner as the requester. How can I ensure that tickets are generated in Zendesk using the actual user who filled and submitted…
-
File Attachment to Multiple Rows in a Sheet
When creating document mapping sheets for Projects, or Functional and Non-Functional Requirements response sheets for RFPs, it would be greatly helpful to be able to attach a single file to Multiple Rows in a Sheet. Now, we can only upload a file to a single row, but if that one file applies to multiple rows, it would have…
