-
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…
-
Conditional Formatting Changed Over This Weekend
I've got a development backlog I keep in Smartsheet. Many of my checkbox columns have conditional formatting - red when not checked - normal when checked. I have header rows that I inserted a period "." into and changed the font color to match the row to hid the conditional formatting. Now, the conditional formatting is…
-
Combining form data with a to do list
We collect reservation request information via form that I can pull into a sheet. However, I would like to have a task to-do list/deadlines/confirmations noted, etc. on the same sheet. My understanding however is that the columns can only be formatted all the way down. Does anyone have a suggestion as to how I can…
