-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
-
Merged: Setting a specific time on reminders
This discussion has been merged.
-
Import Data from Database
Good day, I am looking for a solution that will allow me to automatically populate a Process Owner column in Smartsheet from an Oracle table (for example). From what I have been able to find, the Live Data Connector is not capable of importing data from a Database to Smartsheet (It can go the other way, which in this case,…
-
How to calculate resolution time?
I have a sheet, where via form the Project team submits a Change Request. I need to calculate how long it takes the submit the request until it's marked Approved. We are trying to calculate the resolution time So I have a column called " date of creation" and I have another called "Last review". which will make it easier…
-
Enable links regeneration
Currently links to published spreadsheets or reports are "hard coded", i.e. can't be changed. So if someone either from our or from customer's side is leaving the company, they still have an access to potentially confidential information. This "feature" makes use of Smartsheet in the enterprise area very questionable and…
-
When using workflow automation for weekly notifications does it run just once?
Under this it states that it would give one alert message, I know it is an example, so I am clarifying if it would send it the next week as well?
-
Wacky Start Date When Using FF in Predecessors
Hi there, Working to update a plan today and I noticed that the use of the FF Predecessor Type will cause some weirdness with the start date. I've put an example in the graphic above but the summary is this: If you have two tasks that have the same duration and you want their completion dates to line up, the start date for…
-
Latest Comment Column - can we remove default name?
Hi Smartans Can we remove the name that would automatically appear in the Latest Comment column when a comment has been updated, or changing this to an initial instead of the whole name? Just checking if anyone knows any workaround to this. Thanks all! Syed
-
Use initials instead of username for display
It would be great to be able to replace my full user name (which is kind of long) with initials when displaying on the sheet. Using the "latest comment" column, my name takes up a a lot of screen space.
-
If cell matches cell in another sheet, return value from a column in that other sheet
Im working on a formula that will compare my Client ID column from my current sheet current row, to my Client ID column on my second sheet (called Production Log). When the client ID matches, I want the check date column from my second sheet to be returned. This is my formula. It is giving me an unparseable error.…
