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
Filter option after Building a Report
Hi, After building a report, it would be great if we had the ability to use filters similar to the other sheets. Thanks, Brent
I have a [Start Date] and [Due Date] with Dependencies enabled. I know the dates used for the scheduling will have a time component. Other date columns do not.. I copy the data (Cntrl+C, Cntrl+V) to Baseline columns. Date component matches. I then create Variance columns where Variance_Start = [Start Date] - [Baseline…
Team "Work in Progress" sheet?
Hi All, We have a team of 5, and one manager overseeing their work. Then we have 3x project sheets, with rows of tasks. When the team member starts working on the project task, they click a "work in progress" checkbox on that row. The manager can view the 3 sheets individually and see when a team member is working, because…
Setting up alerts on a Report
We have a report that is populated when a cell is checked off from a tracking list. I would like to send an alert to co-worker when a new row is added to the report.
Calendar view showing indent hierarchy incorrectly..
Hi there, If you look at the attached image you can see the issue I'm having - the issue is that the line items colored GREEN should appear directly under the gray "Universal masthead design / Tone / Messaging" bar since they are indented in underneath it - see task list on the bottom of the attached image. Instead the…
Formula Column - Change Status based on %Complete
I have created a Column called Formula1 and I am wanting to use this column to create a formula that will look at the %Complete and If the %Complete = 100% (1) then change the status to Complete. Currently I have the following as the formula: =IF(%Complete1 = 1, Status1 = "Complete") Problem is I am getting "#NUMBER…
Getting the most recent item in a column
I am trying to create a project status entry form that keeps a running log of updates - and I want to take the most recent update and roll it up to a summary report. The data sheet looks like this: (attached) Line 1 is the summary line that will link to a master scorecard elsewhere. The value of [Report Month] on line 1 is…
Can multiple web-forms feed the same row upon submission?
Good Morning, I would like to have two webforms: one for an external user and the other for an internal user to each fill out and submit separately but have all the information from each webform compile and fill into the same row on the master sheet. Is there any way to link the two web-forms so they can feed the same row…
function dates difference
Hello there! I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854 how can I obtain jus a round number of days?
Feature Request: use Shift-PageUp and Shift- PageDown in sheets
Hi, It would be nice to be able to easily select multiple lines using Shift-PageUp and Shift-PageDown. Currently, I can only select multiple rows using Shit-Up and Shift-Down (of course I can also do it with the mouse, but the keyboard is faster). I'm using Firefox 43.0.4 and Windows 8.1. Regards, Marcos