-
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.…
-
Cannot sort Card view by Assigned to column
Hello I am using Smartsheet to allocate tasks for projects which i use gantt and grid view for. My team need to look at their tasks allocated to them in card view, but i am not able to sort the card view by the assigned to column I do have multiple contacts enabled in the assigned to column, would this cause the problem?…
