-
Ghant Chart with quarter headings
I really like the quarterly level ghant chart. However, when the earliest task begins near the end of the quarter, I have two months of blank ghant. I thought that I could force it to show only the part of the quarter that has a task by specifying a date range. But, I still get the blank part of the quarter. Is there any…
-
Card View Settings Help
How do you make adjustments to Card View Settings after you have created a field? Also how come unchecked fields still show up in my cards?
-
Formula to get averages from one column if another column is checked
Hi All! I have 2 date columns, Processing Start Date & Processing Turnaround Time, then a column to show the NETWORKDAYS, (labeled Average Setup Time), of those two columns. Then I have a checkbox column (labeled New Setup)and another column to convert the checks into 1, 2, 3, etc.(labeled Setups). What I need to do now is…
-
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!