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 September 2016
Discussion List
Orange cell
Why is it orange?
Grouping Tabs
Sorry if this has been asked and answered, but..... Is there a way to have all the sheets in a workspace (or by some other means) open simultaneously (think excel "workbook" with mutiple "worksheets").
Past Due Dates
I am having some difficulty in adding a formula so I can track how many days past due a task is. I've searched other disccussions and I have not been succesful. I am using the "Project Sheet" templete and I have it filled out with actual dates and durations and Predecessors. I have set up two Conditional Formating…
Stringing Logical Arguments
Hello, I have been struggling with this formula for a few days now and can only get bits and pieces of it to work. So I am hoping I can get some help here. Essentially I am trying to create a formula that includes 5 fields and depending on what is in them, give me three possible outcomes. The fields I have are: 1.…
Run Report on 'Highlighted Changes'
we have a large smartsheet with 300 (plus) rows and 25 columns and wish to quickly focus in on any cells that have had a change. I understand how to use the 'highlight cells' function, but the problem is that i then need to scroll down through all the data to see any highlighted changes. Is there a way of getting what we…
Joining two formulas, IF and NETWORKDAYS
Hi I have the following formula but only want it to be run where my task is in a 'Not Started' status. =NETWORKDAYS(Start1, Finish9) Is there a way to run an IF statement first as part of the above formula? I have tried running an IF statment in a hidden column but can't seem to link two together. Thanks Phil
calculate a running total from updated cells
I have a spreadsheet which tracks the order process . A simple dropdown list qualifies a cell as either "quoted" or " PO received". Once that cell has changed to "PO received" I'd like to deduct the qty for that order from "stock in warehouse" so That I can see at a glance how much available stock I have. Is there a…
Date as column type converts the date into US format but not accurately and hence makes the data ina
Column 60 is the accurate information Creation date has had the type specified as Date, it did not work with the dates in march until the 11th of March and likewise for the 1st of april. I am unable to understand the pattern either, can the Date format be used in dd//mm//yy format please
Gantt Chart view for Daily / weekly / monthly Scheduled works
Hi all, We are new to this amazing product. We have separate 9 sites that have numerous different types of scheduled maitenance required at different times. Is there a clear way of displaying this in a gantt chart or spreadsheet type of format? example - Daily clean, weekly service, monthly polish, yearly audit. Thanks in…
Notify Dependent Task Assignee That Predecessor Task Has Been Completed
Here's the setup: I'm trying to get team members to use Smartsheet more. One of the ways I'd like them to use it, is to get them to mark a task as complete once it's been completed instead of me chasing them around and asking them if they've completed the task and then checking it off for them. I'd also like to automate…