-
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.
-
Formula & Conditional Formatting Update in Reports
I have several smartsheets that have formulas and conditional formatting. These smartsheets are pulled into a summary report. The formula's and conditonal formatting do not update when opening the report. Each sheet must be opened individually in order for the formula's and conditional formatting to update.
-
Webforms - Email advice
I like the fact that webforms can be set up with a notification to automatically send an email to a contact. When you complete the webform, it offers you the opportunity to have a copy sent to you. When the notification goes through to the contact (e.g. a manager), the format displayed in the email is a copy of that row of…
-
Messaging
Is there a way to message all the people I have as collaborators? I use this product for construction management and I would like the ability to send a message to all to if we've had a major update on the schedule.
-
Smartsheet Document Library
Has anyone at Smartsheet considered a document -folder/file library built into the platform? I want to allow sharing with an integrated document library so they can use these documents such as fillable PDF's/Word/Excel together with rows in the sheet. This is for a project management system- with a number of stakeholders.…