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.
Discussion List
use of sheet as a blog or project update board
Is anybody using SS as a blog or project update board? We have both internal and external people to communicate with and intstead of trying to make sure everyone is looped in on an email, we were just brainstorming on how to use SS to keep everyone informed, but allow users to post. Somewhat like SharePoint? I was thinking…
Linking cells from multiple sheets to a report
Let me describe what we're doing: We are an agency that has several creative agents working on projects for our clients. Each creative logs hours worked on projects. We need to be able to count the total hours worked by all agents, then report that to the client report in one cell. Does that make sense? So if we have 5…
Odd behavior - I thought it was just me
Recently (last few weeks or so, maybe less - time is blurry to me), I've been noticing odd behavior on Smartsheet. Things like an open dialog (attachment summary for example) would just close. Did I click something? I'd look down at my hand to see if it has taken a life of its own. I don't THINK so. But maybe I'm crazy.…
Web Forms - Show Latest Entries
Hi There - I am using a web forms to add timesheet entries to a smartsheet. Is there any way on the web form to show say the latest 5 entries? Just in case the data entry person loses track of where they were up to it would be good if they could see at a glance the latest entries without having to go into the actual sheet.
Card View: Color Cards Automatically Based on Parent
Is there anyway to color cards based on the parent task? I can't seem to do this in conditional formatting and was hoping to find another way.
Security: Restricition of user rights within reports
Hello, let's say I have set up a report to share information to specific users. Within the report several columns of the underlying sheet are hidden, because the viewer is not allowed to see them. When a user (e.g. with the rights of a "view only") opens the report he only sees the columns that he should see - ok. He is…
Convert text to number
Hi is there a way to convert a text to a number like: "One" to 1. VALUE() doesn't work. Thanks Peter
Date Format - Add the time eg 14/01@0930
Is there a formula available so I can create a date like the following? 14/01@0930 or is there any plans to have more date format options? Such as DD/MM @ HHMM
How do I automate and validate data from one column to another
For example, have a list of cost centres in one column using a drop down list, now I want the managers name for that cost centre to populate in next column. In excel i would just use a lookup or match/index to validate and populate. Cannot work out how to do it in smartsheet.
Card View Feature Request: "+Add Card" link at top of columns
If you have a list of cards in a column is too long to fit on the screen, you need to scroll down to hit the "+Add Card" link at the botton of the column. It would be great to have quick access to this without needing to go to the end of the list, could a link or button be added at the top?
