-
Best way to share specific rows for edits
Hello - I have a SmartSheet containing several rows with thumbnail images and product information. Hundreds of additional rows will be added as the year progresses. I will need clients to review and add information for groups of rows at a time. As to not appear overwhelming, is there a way to only share the rows that are…
-
Naming a Cell
Can Smartsheet let you "Name" a cell, like in Excel? This would be really useful. You could name certain milestones like "Launch Date" and then automatically calculate the dates of other tasks by subtracting/adding from that. For example, the due date for "Approve Launch Publicity" could be =LaunchDate-14 Today you have to…
-
New JIRA tickets don't appear in linked Smartsheet file?
I'm using the JIRA+Smartsheet connector app. I created two sample JIRA tickets and was able to get these tickets to appear in a Smartsheet file. I then created 600 new JIRA tickets and these aren't syncing to the same Smartsheet file even though the same filtering criteria should be met. Can someone help me to troubleshoot?
-
Logical Update Request
I am thinking about a scenario with an automatic update request: On the task start date, send an update request to the 'assigned to' column. On task completion , send an update request to the 'assigned to' column. Looking at the new update request functionality I am wondering if anyone has thought of a way to do this.…
-
Detect if cell value increased or decreased
Is there a way to detect if a cell value increased or decreased compared to its previous value? I've already devised a way to reflect a symbol if the auto-column date modified was today. Now, I want that symbol to vary depending if the value on a cell in that row increased or decreased. Or if there's a way to put in two…
-
Use Smartsheet row data to populate a Template
I am looking for a way to automate a process to take data from a single row in Smartsheet and populate a template. Working in the construction industry, processes are slow to change and we still need to PDF documents for communication with our customers (RFI's, Change Orders, etc). I have setup the forms and procedures for…
-
#UNPARSEABLE
I am using the following formula to calculate the net days but only if the dates are listed. What am I doing wrong? =IF(AND(ISDATE([Date Received]3085), ISDATE([Processing End Date]3085)), NETDAYS([Date Received]3085, [Processing End Date]3085), "") Thank you much!
-
Gantt Chart Display
Does anyone know if there is a way to display the children (multiple) under a single parent in the Gantt Chart? I have a chart with several children per parent and would like to display them all under their respective parent. Each child has a set of start and end dates; the end of one child is not the start of the next…
-
symbol column to add workdays in formula
Hi, I want to create a RYG status if a date is late. If it is one workday late it is "Yellow", if it is 2 days late it is "Red" and all other are "Green". The End Date is the due date. The underlined formula will show 2 calendar days but I need workdays/vacation included. Any ideas on how to resolve?…
-
SEND REMINDER ONLY IF TASK IS NOT COMPLETE
How do I setup a reminder to only email if the "Complete" box is not checked off? It seams that there is not a way to add a condition in the reminder setup.
