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 2015 Posts
Archives for October 2015
Discussion List
Cell reference formula
How can I create a formula from two columns that will result in pulling in the value from a third column? Column1 (text) = Column4 Column2 (text) = 3 Column3 (date) = Column1 + Column2 Ideal Column3 result = [Column4]3 Please let me know if I can clarify anything, it is a little confusing. Thanks
how do i put columns down left handside of sheet
as above
What data is sent to Zapier on the updated row trigger?
Hi, I want to send a custom email with data of a row when some of its cells are updated. The recipient of the email is in a column of the row. I try to do it with Zapier using the "Updated row" trigger but it seems that the data sent to Zapier is all the sheet and not only the row. Has anyone faced this? How could I only…
Confused by NETWORKDAYS results
I have a formula such as: =NETWORKDAYS([Planned Start]1, [Actual Start]1) When the Planned Start date is say 10/29/14, and the Actual Start date is 10/30/14, the result is 2. To me, the difference between those two dates is one day, not two. I don't have any holidays set for these dates, and I've tried wrapping Actual…
Hijacked again ... have to go 40 pages in to get to real comments
What's up with the continued spamming? Need to hire these guys to do something constructive.
Send update request with selected columns when certain conditions meet
Hi, Is this planned to implement as a new feature that sending an update request automatically when certain conditions met? For example, I need to send update requests to next approver for rows that checked as "Approved" by previous approver. Columns should be selectable when setting up the update request. I want update…
Fixing the Gantt timeline to Years and Months
Hi all, Something is driving me a little crazy and I wonder if anyone could help? Our client likes programme timelines to be displayed like this: - primary heading: years - secondary heading: months This works fine until someone zooms in or out (using the +/-) buttons on the Gantt chart. When they zoom they are unable to…
Mobile App Report Issues
I just started to use the mobile app in conjunction with the Reports and I am running into some functional issues. When I use Reports on my PC and want to go to a specific line from a report, all I have to do is click on the linked report. It takes me right to the line I was looking for. When I go into a report on the…
One tab, multiple reports?
Smart Sheet has proven to be an amazing tool. In using it, I have built several reports that are starting to take up too much space on my display. Some of these reports are very similar (Quarterly reports, for example, are taking up four tabs per year) and I want to consolidate them into one tab. How do I create multiple…
Where is the Smartsheet cloud housed?
Is the Smartsheet Cloud housed within the United States or outside of the United States? I ask because our PMO is mandated to use only tools housed within the United States.