Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for January 2016
Discussion List
Produce a report for a particular day
Is it possible to produce a report that shows all items from all sheets which are due on a particular day?
Search and Replace with <null>
Anyone know what the null value is in Smartsheet when using the search and replace function? I tried, "", <> and all the usual tricks- no go. I want to search for a particular word in a string and replace it with.....nothing.
Changing the ball color on parent based on color of children
What I am trying to do is change the color of the RYG ball to red if any of the children have a red ball else leave it blank.
Date Formulas Calculating Back From Deadline with Gantt Functionality
Hello Team Spreadsheet, Ultimately we'd like our company to enter a date that they would like to have their marketing materials and have smartsheet automatically calculate key dates prior to this date including the initial submission date which should be around 5 weeks prior to the end date. Here is our marketing team's…
Using Formulas in "Assigned to" collumn?
I'm a newbie here so don't be too harsh! I am trying to determine if if is possible to set up a dependancy to auto-assign a task to a team member. At my law firm I am creating a few templates that assign certain tasks on each case to one of several paralegals or attorneys. What I'd like to be able to do is designate in a…
Add-on Smartsheet Merge for Google Docs
I've a question about the "Image in a cell" feature in Smartsheet: Will it be in the "Add -on Merge" for Google Docs available too? It would bring a real usefull enrichement in data output processing to presentation level.
Calendar view - more than two dates / no start-finish date?
A bit of a strange question here. I'm working with a team that deals with e-news. Smartsheet is used to record the individual news pieces, who the recipient is, and the date that it is being sent out. Each news story goes out on three seperate dates (current week's Tuesday, current week's Thursday, next week's Tuesday).…
IF(Is Parent Row....
I am using the below to calculate the "days since last contact" and it works nice. However, if the row is a parent I want to retrun blank, i.e. <> =IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, "Never") The formula for check is a parent row is…
Workspace Sharing
In September at SmartSheets Academy the Smartsheet team said that there would be changes in the sharing of Workspaces by the end of 2015. Is there any update on this?
Why does smart-sheets forward you to a maintenance page for maintenance and then not forward you bac
This confused me as I did not notice the date right away. I went to breakfast and came back before I realized it was yesterday and the mainenance page does not automatically forward you back to smartsheets. I refresh the page and expect to be back online. Not super frustrating but a little dumb if you ask me. Can we adjust…