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 April 2016
Discussion List
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…
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..…
SUMIF condition is met
I have a billing projections sheet that I am trying to figure out how to sum (total) the Current Year to Date billing of a project manager. I have a Project Manager column and Billing CYD column. Here is the formula I have so far... =SUMIF([Project Manager], Name of Project Manager, [Billing CYD]) Obviously this does not…
Personalising Column Hiding
Why cant Cloumn Hiding be made personal, like filters? Im my company, we use large sheets (lots of data and columns). Each collaborator uses different collumns at a time. why can each user personalize hiding like filters?
Custom webform
How can i create a custom form in a php cloud app written for one of our clients. The meaning here is to create a custom webform for a support call (like a webform in smartsheet). We don't like to use the iframe embedded code here but want to make our own support form. But the result are the same. Items filled in in the…
% 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.
Is it possible to add a Chart to a Sight?
Via the Smartsheet Labs I've created a number of charts. I'd like to publish those into a Sight. I can't for the life of me figure out how. I'm hoping I'm missing something very basic.
looking for a chain of custody or asset tracking template
We are looking at creating a chain of custody document to track assets that get transferrred to other people. Are there templates out there or does anyone use this?
Dropbox and Desktop Version (Chrome App)
In the chrome app (from the desktop link) attachments from dropbox is not an option, while it is on webversion. Any solution?
Parent/Child Row Formulas
I have two questions... First, I am trying to sum all the values in a column so that when I sort by a specific column the formula does not get all jacked up. Second, I have another sheet where I trying to sum the values in the child rows to the parent row. I understand how to do that but everytime I sort the sheet on a…