-
Subtask dates populate from parent
Hi, Does any one know if there is a way to auto up date a subtasks dates when you move the tasks between parent tasks? The scenario is we have a course booking tracker and the PARENT task is the course instance and the SUBTASKS are the attendees. If we need to change the attends course slot we would like to drag to a…
-
how to find out if an email exists?
Hi all, I have a list of people with emails in my smartsheet. Some of them left the company, how can I find out from smartsheet that their email not exist anymore and to mark them in the sheet? Thank you, Joachim
-
Add to a date if another column meets criteria
I'm not the best at the complicated formulas and need some help. I have 3 columns in play here. Submission Type (single select), Submitted date (automation added), and Due date (Date Field). If the requestor selects "Standard" in the Submission Type field, then I want the due date to be 30 days after the submission date.…
-
Timeline Variance indicators
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Smartsheet allow for WBS elements to be created through indent / outdent similar to MS Project? Can Smartsheet allow linking to…
-
Column Formula Changes - Change Cell Value
Hi Community, I have a column that contains a column-formula it has 3 options/ratings: "1-Great", "2-Not Good", "3-Bad", I set up an Automation that if it changes to 2 or 3 it should check a box in another checkbox column, but this is not working. I have another Automation that if it changes to a 2 or 3 it alerts soneone,…
-
Is there a way to Cc myself on all automated alerts that are sent to contacts in a specific column?
For documentation purposes, I need to Cc myself on all automated alerts that are sent to a vendor to notify the vendor that a warranty claim has been assigned to them. I set up a workflow that sends an alert to each contact that is included in the "Vendor(s)" column, but I have no way of documenting the fact that the…
-
Function statement giving me date 4 month before due date.
Hi, I have a column of due dates, I need a column listing a day four months before the due date. This will be my project start date. I was looking at =IF(MONTH>4,[Due Date]@row, Any help would be appreciated. To add on to this. I plan to set up an automation to copy rows to another sheet on the week (or day) they are due…
-
Using CountIfs with several criteria including names, status, and date range
I've created a sheet to build metrics from a very large source sheet. I'm trying to count based on the following: the column {Module 3 - Section Owner} matches a cell in this metric sheet in the "Primary Column" a Date in the {End Date} that is between Today() and the next 7 days. I created three cells that determine what…
-
Unlock multiple rows automation after approval
I'm trying to automate the unlocking of multiple rows, triggered by an approval request being approved. Reason being: want to force users to submit a proposal before moving on to the next project steps. Here's my automation setup: Here is my sheet, where I just did a test approval request. The above alert sent to me as…
-
Requesting update to specific people and only linking their projects
I'm keeping a portfolio of my teams projects (150+). Once a week, I'd like to send out a request update for each person to update their assigned projects. I can't figure out how to send out the request update only to those linked to their projects. As an example, I added a condition that if Project Led by was "my name"…