-
Automation involving 2 rows
I have a sheet with a list of tasks that need to be done. Example: row1, checkbox, task name, who, start date, finish date row2, checkbox, task name, who, start date, finish date I would like to have the checkbox in row1 to trigger an alert to the who in row 2. Can someone share if this is possible and if so how should I…
-
How to manage resource loading from a master sheet.
Hello, I trying to create a master sheet of a set of projects in order to help with resource loading questions. I can easily create a report that displays all the tasks for employee A vs employee B. I can create a report on all tasks across all selected projects with employees A-E. However, since we cannot use formulas in…
-
Weekly updates when Trigger is set to "when a row is added or changed"
Good morning, I am trying to send a weekly report of changes on a sheet to a group of users. The best way I have found to do this is setting up the "Trigger" to be "When a row is added or changed", however when I do this my options are limited when it comes to when I want this workflow to run. If I select "Weekly", I do…
-
Equipment Inventory Management
We currently do field work that requires different crews to use equipment from a common inventory. We have three pieces of equipment in inventory. I would like to be able to allow a crew to block off specific dates for that equipment, and show the remaining team members what dates are available to use. Essentially a check…
-
Moving rows
I was wondering if we can move attachments within different rows in one SmartSheet (eg. an attachment was put by mistake to row 19 and we need to move it to row 25). Thank you!
-
Why is my automation not working properly?
I set an automation to alert me about a date that would occur in "the next 30 days" but it didn't alert me until the date hit. What am I missing? Example, date was 10/31/20, automation set to alert when that date occurs in "the next 30 days". I got an alert on 10/31/20.
-
Project planning for an Agile development
Hi, I would like to understand how do you prepare a project plan for an Agile software development. I understand that first the product backlog needs to be created containing the list of features/bug/enhancements that are needed for the release and subsequently during the Spring planning, the tickets are discussed with the…
-
How can I limit the numbers, in a curve?
Hi, When I am using a chart widget in my dashboard, I need to limit the numbers. e.g. I am making a progress chart, obviously, it is something between 0-100%. But my x-axis shows more, for instance it shows 0-120%. It is ridiculous to show a progress bar chart off %0-%120! How can I limit that?
-
Column properites with CLOCK FEATURE
Hi all , We have column with date properties which is great to set the rows with actions /alerts and conditional formatting But I can not believe till today we do not have the same for CLOCK ? many tasks are set to be done at specific time but i can not add my actions and alerts based on time let me know if any plugin or…
-
Shared subasks
Hi everyone, I have one problem I'm trying to solve for the last couple of days. If you look at a picture below I have some group of preparation tasks and I have two delivery. Preparations in booth deliveries can have the same dependent tasks from preparation group of tasks. I´d like to attach somehow tasks form a bottom…
