-
Formula to check Child Row checkbox if Parent row contains "ABC Dept" (filtering by Department)
I have a "Master" project resource sheet with great grandparent rows for "Current Projects" and "Future Projects", Then grandparent rows for each "Project", parent rows for department and child rows for the individual resources per department. I'm trying to create a filter to filter resources by department across…
-
Formula for taking an average of duplicate rows
I'm attempting to construct a formula for taking averages of multiple ratings from several raters across three vendors. Sheet 1 looks like: Rater - Category - Vendor A Rating - Vendor B Rating - Vendor C Rating Sheet 2 looks like: Category - Vendor A Rating Avg - Vendor B Rating Avg - Vendor C Rating Avg On sheet two, I…
-
Must start / must end date restrictions
Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Project Manager for projects within the administration environment I do have a desperate need Smart Sheet does not cover. It…
-
Auto Populate second sheet
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
-
Filter not Working: Is not in the last (days)
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
-
recurring update requests
I setup a recurring update request workflow to send an update request out every other week on Monday Mornings at 10 am. It worked fine the first time around but it doesn't seem to work consistently. I assumed that every time it runs it goes through the sheet and finds all lines that match the criteria. Is that not what it…
-
Date Format
Hello, When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This data will then be pulled to another application (Domo), but it needs the correct format when being transferred over. How…
-
Automatically uncheck column based on date TODAY()
How can I get columns unchecked automatically when they meet a date criterion? For example, all tasks checked today will be automatically unchecked tomorrow because the calendar date has changed.
-
Capture Row history using API?
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
-
Dashboards
Hi All - I am trying to create a dashboard to be shared with the team(s). Something with colors would be great! A list of all the projects and their status in a graph (or pie chart). Something with colors would be great! Any ideas?