-
Avoid multiple emails sent to same person on an automated workflow
Hi everyone, could I please ask for a sense check here? I have set up this Workflow. There are several different people in the 'Assigned To' column, and when any of their dates change, I would like Charlotte (their manager) to receive one single email to alert her to that. It's very possible that their dates could change…
-
Formula for percentage complete and duration remaining
I am trying to develop a formula to flag tasks that are less than 50% complete but more than 50% of the duration has passed. I'm not sure if my math is correct. But aside from that, can Smartsheet perform functions like the one I am proposing below? Currently, it returns an unparseable error. If I get this formula to work,…
-
Nested If Formula
Hello, I am trying to create a nested IF formula based on the criteria below. Below is also a screenshot of what I am trying to do: =IF([% Complete]1=0,"Not started" =IF([% Complete]1>=0 and <=1, "On track" <code class="CodeInline">=IF([%Complete)]1=1,"Completed" =IF([%Complete)]1<=1 and Due Date is past,…
-
Calendar with Time Slots
Does anyone know how to create a calendar that allows multiple entries per day, and shows time slots such as a meeting for example? Basically looking for a calendar in smartsheet that resembles an Outlook calendar that I can use on a Dashboard. Thank you!
-
Creating forms
I would like to know if it's possible to create a form template associated with a Smartsheet. The purpose of this form would be to collect requirements for a request that a client enters into a Smartsheet. The client would access template, complete the fields, save it, and then attach it to a specific line item in the…
-
Product Development Testing Template Set
I've reached out to our account manager and also sent a request via the web form, but have not heard back from anyone. What I've been looking for is the "Template Set" for the Product Testing solution (Test Plan, Test Log, Bug Tracking & Submission and Bug Report). I've reviewed it "Create New -> Browse Templates" but…
-
CountIFS & Counting Dates
Hi All, I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and the Date Installed has a date then I need to return the value for the total number of existing devices installed. Any help…
-
Updates to Master sheet automatically updates individual projects
our company has multiple projects that have the same tasks, durations, and dependencies, but have different start and due dates and different assigned staff. We are creating a master project template that can be used as the starting point for all projects, but we would like a way to make updates to the master project…
-
At Risk Flags
How do I format my At Risk column so the flags only appear in the "children" rows, as shown in the screenshot?
-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
