-
Notification Not Working
Hello! I am trying to setup an alert to notify me right away if the percent complete changes for specific rows in my Smartsheet. I set up an alert to notify me when "a row is updated" and selected the specific rows (Task Name) I need updates for. When I went to test it out by updating the % complete for one of the…
-
Cross sheet formula/reference
Hi everyone, This may be a basic answer, but I am trying to build a dashboard for my company. I have 6 reference sheets that I want to filter into 1 large sheet (the dashboard). The dashboard is an accumulation of weekly data that the 6 sheets feed into. Each sheet has a different employee inputting different data. So, If…
-
Symbols not changing based on the value in another cell
Hi. I have applied a formula where RYG "status" column is counting days to deadline and changes colors according to how many days are left till deadline (=IF(Done3 <> 3; IF(TODAY() - Due4 > -7; "Red"; IF(TODAY() - Due4 > -14; "Yellow"; IF(TODAY() - Due4 < 6; "Green")))) Now i want to add another formula to column(Drop…
-
Either / Or but not both
Hi Could someone help please? I'd like to set a formula in a sheet with say 3 columns. It needs to sum/count depending on the answer of the first two columns but not them both. If either of the columms say "Yes" then that is good enough to be counted in the 3rd column. For example: Column A: Yes Column B: Yes Total: 1…
-
Is there a way to send an attachment using Alerts & Actions?
I would like to have a Business Case sent automatically (as an attachment) when specific conditions are met after a web form is submitted. Is this possible? Thank you
-
Cell Linking
I have watched many videos but cannot seem to master the cell linking between sheets. I've tried multiple ways but never receive the results I'm looking for. I have a project on a sheet Named Eblasts and it has subcategories of Months of Year and then Tasks subcategorized under that. I would like to link the whole Eblast…
-
Row showing sprints at the top of the Gantt View
Hi Does anyone know if there's a way to add a row directly underneath the date row showing sprints? So one row that shows x weeks for sprint 1, sprint 2 etc, directly under the dates where they sit? This way when you look down the Gantt Chart you can see what sits in each sprint by looking at columns instead of rows. I…
-
Resource Allocation in Manufacturing
Hello, I am curious if anyone has tried to use Resource Allocation for capacity planning in manufacturing. Our projects are long term releases against blanket orders and I would like to use the Project Sheet to view where Production/Manufacturing resources are over-allocated and prove the need for additional staffing or…
-
Formula Predecessor Help 2...
I could use some help. I've implemented J. Craig Williams' predecessor solution allowing notifications based on the predecessor being complete for a given task: 1. Create a column to get your Row# [RowID] In the first row, put a 1. The second row, use the formula =RowID1 +1 and copy that to all the other rows. 2. Create a…
-
Report - sum a column
Hi all, I have multiple budget spreadsheets and a related report which I point to one budget sheet at a time. I can then report on just one month at a time (example: project A, October totals). Is there any way to sum the cost column for the items returned in the report?
