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
Sharing
Hi there SS community, If I am running several sheets, when I share a sheet with someone... is that the only sheet that person sees? Thanks,
Very strange formatting issue
In my sheet, I keep my primary column font color "Red" until we take the first action. At that time I manually change the color to "Black". I do not have any conditional formatting that has any control over that column. I do have other columns that do have conditional formatting controlling them. Here is the strange part..…
User Management
Hi All, Hoping someone can help me out, I am unable to see all users in the 'user management' view. If i go into the individual sheet i can see through the permissions users which have been set up, however if i go into 'user management' to delete them i am unable to do so because i cant see them there. secondly is there…
Renaming a worksheet as editor
If a workspace has been shared with me and i only have editor - can share permissions can i rename a worksheet within that workspace for example: the sheet has been set up as a template with the name Campaign #1, can i then change this to reflect the actual name of the campaign ie. Christmas holidays.... ?
RSS Inbound Feed
I'd like to take an RSS feed and have it populate rows in a SmartSheet document. Is there a way to consume external data so it is automaticly added to my documents?
Can I use a form to update the same line on a spreadsheet multiple times?
I have a webform that I will be sharing that is supposed to track multiple attempts (using dates) to schedule a meeting with an outside vendor. The problem is that the form makes them re-create the data each time and populates the spreadsheet in a different row.
% Complete column can only be updated manually?
Is it true that a % Complete column for a gantt chart can only be updated manually? It would be beautiful if I could use a formula which would update it automatically.
=AVGIFS Function Workaround
So there isn't an AVGIFS function currently in SmartSheet, but I still need to find a workaround. I came up with: =IF(AND([Project Manager]="Name",[Owner]="Name",[Project Status]="Complete"),AVG([Days to Complete]),"") However I am coming up with a "MISSING OR INVALID PARAMETERS error. I have pulled the averaging portion…
Duration in parent row not calculating
I have a parent row that is indicating duration of its child rows as 78,324 days when in fact it's actually 53 days--February 1 - April 29. (I made sure the dates were all in 2016). I had one row that was showing several thousand days when it was actually 21 days. I fixed that and saved the sheet but the parent row is not…
Feature request: Column for tracking time automatically
Smartsheet should add a standard column. Initally it includes a button syaing "start". When pressured on, a clock starts running in the background and keeps on running until one press the same button ( displaying the accumulated time for the task) or until the same user press another "start" button in the same or any other…
