-
Limit rows in a sheet
Is there a way to limit the number of rows created by a form? I want to use a form for people to register for a training event, but am limiting the number of attendees to 50. Is there a way to automatically deactivate the form when 50 rows exist in the sheet?
-
People AND Equipment scheduling
Hi, I am trying to move my company away from scheduling via excel and get it onto a live panel where everyone can see who is doing what and when and most importantly with what equipment. Hence I'd like to get input from the community on what is the best way to schedule people and equipment in the same space so that neither…
-
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…