Hi, I am working in a date column that has the Effective Date: 05/13/2019. I want the Project Kick-off Date to reference the Effective Date - What formula do I enter so that: (i) the Year is always th…
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…
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 ac…
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";…
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 columm…
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
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 …
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? T…
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 Projec…
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# [Ro…