-
Mail Merge Multiple Rows of Data
The task that I am trying to accomplish, is to complete a complicated mail merge for mass email. The mail merge function in MS Word or Google Docs sends out emails based on each row in your excel data sheet. Each row equals 1 email to 1 recipient. The issue is that multiple rows of data have to be sent to 1 recipient. If I…
-
Create percentage complete based of boxes checked
Hello, I am very new to smartsheet and still quite inept. I have a smartsheet that I am using to track a student I am mentoring. There is a coumn titled 'Completed'. This allows the student to check when a specific task is complete. I want to be able to show the percentage complete based off how many boxes are checked as…
-
Predecessors "tolerant" to deletion
I'm trying to figure out if there's a way to set up our projects so that some very specific tasks, which may normally be predecessors to other tasks, can be DELETED without resulting in an ugly "#REF" error on the subsequent row. We would want this because we have several different "tiers" of projects depending on the…
-
Cell linking - finding the next empty row on another sheet
Hi, Looking for a way to link a cell in each new sheet to the 1st column of the next open row in a summary sheet. I have a template sheet and summary sheet. I would like to create a number of sheets from the template and then display some info from the sheet in one row on the summary sheet. It looks like this is commonly…
-
Website form integration using API
I am attempting to use the API to add comments into a new row created by a form submission. I am currently adding new rows to sheets through forms on our website that integrate with (amung other things) the Smartsheet API. Our website utilizes C# so I am using the following code (partial) to submit to a sheet. Cell[]…
-
Automating RYG balls based on completed dates in parent row OR children rows
Hi all, I have a sheet with parent rows where the status column is updated with a RYG ball based on the completion date and due date of the row: =IF(ISBLANK([Due Date]108), "", IF(ISDATE([Completed Date]108), "Green", IF(TODAY() - [Due Date]108 > 0, "Red", IF(TODAY() - [Due Date]108 > -7, "Yellow")))) The children below…
-
Training Plans and Curricula
Does anyone have any templates that would show generic training plans?
-
Report is pulling correct results, but cells are blank
I have a set of project sheets that all share the same basic layout and format, AND also have all the same sharing permissions -- specifically, I am the owner of all of them. I'm trying to generate a report that shows me all sheets with an End Date in the future for a specific task / row in the sheet. The report seems to…
-
Card View Vertical Drag changes value
I love the new card view but in each vertical lane I'd like it to organize by the priority value. It would be great to have it automatically set the priority 1 higher than the card I just drug it above. And it would be great if it put it in order of the Priority Field if I edit them directly.
-
Date-based formulas now broken across 100+ sheets
As a result of the latest release and supposed "formula enhancements", we now have more than 100 client-facing project sheets whose "status" column is entirely broken. Previously our status column looked at the task Start Date, End Date, and Target Date, and intelligently spit out a text value such as Due Soon, In…
