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 2017 Posts
Archives for October 2017
Discussion List
auto populate start date based on sprint number OR vice versa
Smartsheeters, I am looking to auto-populate start date based on entering a sprint number. OR to auto populate sprint number based on start date- I assume that finish date will be auto populated based on duration entered (10d). I am fairly new to smartsheet so keep that in mind Any ideas? or Articles to share? Thanks,…
Is there a formula for averaging the remaining?
Hello again! I have been trying to figure out a formula for averaging the remaining. This sheet has all business days through Dec 8 and a certain number of tasks to complete each day to be finished on time (Dec. 8). There are two columns. One has the number of tasks due to be completed each day (labeled Average) and the…
Prevent column name from showing up in Sight
This topic has been discussed before, but, for whatever reason, that discussion is frozen. When using the metric widget in a sight every selected cell will get the name of the column it's in as a passenger. While I can't find any reasons for this approach, it would be nice to have an on/off switch. I know one can remove…
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
Sharing With Non-Licensed Users
I have shared many sheets with non-licensed users. They do not have a problem accessing them with the initial email but do not know how to find them later. Are they able to access them if they type the Smartsheet URL into their web search?
Time Tracking integration with TimeCamp
Hi all, It was recommended a while ago that we use integration with TimeCamp to track our time because SmartSheet does not have that capability (and boy do we wish it did!). TimeCamp seems to be able to synchronize with SmartSheet and pulls all the tasks for a project if the are in the primary column. Our employees track…
Creating dependancies so I can change my start date
I am setting up a project plan but at this time I am not sure what my start date is. I can set it up with a possible date and create my tasks and dependnacies. But how can I make sure my dependancies are set up correct so that when I change my start date everything will fall into place.
Flagging Red using two conditions
Desperately trying to find a formula that does this: if due date is past and checkbox is blank then flag red in Symbol column For Row 15, tried this but it is not parseable. I used this formula in the Flag column =IF(AND([Checkbox]15 < 1,TODAY()>[Finish]15)1) says UNParseble
How to collect comments from individual sheets, cell-link to a master sheet (eventually Sights)
Hello everyone, For my dashboard (Sights), I show status updates from individual projects. There are multiple updates columns per project I have to pick up. For now, I added extra rows on top of project, and people fill in updates there. Then I cell-link those columns to a master sheet (and create a report for dashboard).…
excel doesn't recognize text/number column from smartsheet
I've linked an Excel worksheet to a Smartsheet report it works fine but one column that has a numbers and text (p.i. 4551A) is imported blank (no data). When is a regular number imports it just fine. Does anybody have any idea what could be the problem? Thanks, Herb