-
Duration
Hi there, Does anyone know whether a duration can be entered in months in the Project template? My template doesn't recognise it. Thanks, Paul
-
NESTED IF FORMULA WITH PARENT/CHILD ROWS
Hi everyone, I am struggling with a formula to populate a parent row, as either "On Track" or "Off Track". This is dependent on how the child row compares to the "Weekly Goal". The formula I am trying to use is shown below but, Im doing something wrong. (screen shot of sheet also attached) =(IF(CHILDREN([January (Week…
-
Automated Update Request rule is in red font
I created an update request to be automatically sent today @ 11AM Central time. The time has come and gone and the request criteria is now in red font. It appears the request was sent, but why is the criteria in red font now? My "Contact" column is a contact list column. All fields are contacts with valid email addresses.
-
Posting Dashboards
Is it possible to post a dashboard to your desktop? Being the owner of several dashboards, I would like to make it easier (if possible) for the editors to access them. I was looking (hoping) for a way for them to post their individual dashboard to their desktop or at least a link that would take them directly to it. Thanks,
-
Calculating Awarded Estimates
I have a running list of estimates we submit. when we are awarded the project that column gets checked. im looking for a way to scan the entire column and report back the percentage of estimates we have been awarded to the total number we have quoted to date. I would also like then to check how many awarded projects have…
-
Supplier Management - Template
Hi, I cannot find a pre existing template in smartsheet templates Do any smartsheet users have an existing template on their smartsheet account for Supplier/Vendor Performance or Evaluation, preferably with pre defined criteria, and pre formatted score chart and graphs? If so, are you happy to share this template? Thanks
-
Display list of Children
I am looking for a way to simply display a list of children (child tasks). This is identical to Predecessors, where you set the predecessors of a task, however I want to display the list of tasks that follow the current task. Any ideas would be very much appreciated! Mark
-
Can I highlight non-working days and holidays in report based gantt charts?
I have a report referencing several worksheets that I use primarily in gantt chart view. When I print it's gantt chart, I would like the weekends and holidays highlighted the same way they are in a worksheet based gantt chart. Is this a check box I am missing somewhere?
-
How to merge cells?
Is it rellay cannot merge cells in smart sheet???
-
Card View Edit - Jumping to top
I'm working with a sheet in card view and when I click on one of the cards to edit, a form pops up. If I scroll down on the form and try to click on one of the dropdown menus, it jumps me right back to the top of the page and I'm unable to edit. I've tried this in both Safari and Chrome and keep getting the same outcome.…
