-
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,
-
Summarizing and aggregating for the same code from multiple sheets
Dear Expert, I have 40 sheets containing following column with example (example for one sheet only): Equipment ID | Equipment Group | Part Name | Quantity | Unit Price | Total Price 11MBX21 | AAF | Bearing | 2 | 150 | 300 11MBX22 | AAF | O-ring | 1 | 50 | 50 11MAK10 | BAC | Sensor | 2 | 500 | 1000 11MAD15 | BBA | Switch |…
-
Advice Needed to Optimize Workflow
Hello, I am looking to build a workflow for a review process in Smartsheets. There are multiple stages to this review process. For example, the item is submitted for Group A review. It must be approved by Group in order to be Submitted to Group B. What would be the best and most user friendly way to track who is reviewing…
-
Need a conditional formula to automate status column based on values in date columns
Here's a screenshot of a very simple sheet I've set up where I've manually set the Status. I want to automate the value selection from the "Status" dropdown based on the presence of dates (Actuals) in my Start and End columns: * If the Start and End columns are blank, Status is "Not Started" * If Start has a date and End…
-
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
-
Stuck on If Statements
Hi team, I'm building a dashboard and I need to show the current metric. I thought I'd show this by showing each month (for a chart) and using this formula to obtain the current: =IF(DEC3 = "", NOV3, IF(NOV3 = "", OCT3, IF(OCT3 = "", SEP3, IF(SEP3 = "", AUG3, IF(AUG3 = "", JUL3, IF(JUL3 = "", JUN3, IF(JUN3 = "", MAY3,…
-
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…
-
How do I return a value, based on a date, between dates? (versus week numbers)?
I am trying to return a value to a cell, based on a date condition at the top of the column. For example, if there were 52 columns of the "week dates" in a year. The parameter for the return value is IF the date condition falls between a start date and finish date. I have been able to do this when I convert all dates to a…
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Editing uploaded files
I am project managing construction jobs and have been given the task of auditing contractors whilst they are on site. I have uploaded the audit forms onto smartsheet as an attachment and I was hoping to edit them while I was on site without downloading them and re-uploading them. The files I am uploading are word…