Discussion List
Automating Risk Alert (Ancestor Row)
Hi All - I'm trying to configure my "risk alert" column so that the if any of the tasks or subtasks are flagged as being at risk that the very first cell on the top (next to project name) is automatically updated. I've attached a screenshot to give a visual. The formula that I'm using for the risk cell for the ancestor row…
Is there a Smartsheet Process Map Template or Lucidchart Integration?
I am building a one stop shop Dashboard for Productivity. Anyone been able to pull in a Lucidchart Process Map or Data Flow Chart? The team leans very much to a more visualized process interpretation.
Help printing Gant chart
This discussion was created from comments split from: Need to print a Gantt chart.
How to keep a list in order when drawing from a dynamic source
Hi all, I have a list of projects in a status update sheet. This list is automatically updated from a sheet that receives updates from a JIRA to Smartsheet connection. My issue is that the list of projects is in a priority order (with a seperate column to give a priority number), but sometimes when the JIRA pull sheet is…
Staff Allocation
I'm looking for a template so I can allocate staff. I have 15 staff and they work in 16 different work queues; each with different volume. I would like to build something or use something that helps me allocate them to the different WQs based on volume influx and productivity metrics. This is a more permanent assignment…
How to copy questions when designing a form
Dear All, Do you know an option how to copy questions when designing Smartsheet form? I need to use several sets of the same questions with some minor changes and it would be great to just copy them than designing them from the scratch ... If such option exists and you know it, please let me know. Thank you!
Managing fields displayed in an automated update email - placeholders?
I need to create an automated update message that will be sent to executive leadership. The message contains three columns from eight rows on my project sheet and has a link embedded to the published sheet. (See below) I need to remove the link automatically inserted at the top of the message. I tried placeholders (which I…
Simplification of Formulas for Formula Cell Reference Limit
Hi All, I recently reached this limit for a sheet that was implemented. I have 6 columns that pull from a reference sheet. For example: =INDEX({MWN Ref: Supervisor}, MATCH([@Email]@row, {MWN Ref: @Email},0)). I don't believe that those columns are the issue. I have two separate columns that I will paste below that I need…
Multi-select dropdown into multiple rows
I have multi-select dropdown column. (Data will be entered via form and there will some approval automation.) I have two questions. Is it possible to select individual items within the multi-select options. I was planning to use some kind of delimiter within the options and use index but wondering if there is a more…
Formula to check 2 columns and give a total
Hi, Im looking to create a dashboard that tracks MI tasks, but within 1 sheet it will contain multiple proejcts. To combat this, i have created a "header" field, this marks the title of each project. Each project also has a status Is there a formula i can write that checks if header is ticked, then count status as 1 if "in…