-
Flag as At Risk if Due Date in Past and Complete = X
Hello, I'm looking for support on what formula to include in the Flag symbol column that would act against the following: If Due Date is in the past and Complete = X (Visual Symbol), then flag At Risk column with Red flag Currently, using formula below to flag At Risk column with Red flag based on requested due date…
-
Calculating Awarded Estimates
I have a running list of estimates we submit. when we are awarded the project that column gets checked. im looking for a way to scan the entire column and report back the percentage of estimates we have been awarded to the total number we have quoted to date. I would also like then to check how many awarded projects have…
-
multiple If AND/OR statements
Spent a lot of time on this and I'm sure I'm just missing it so if anyone could help, I'd appreciate it. I'm trying to create a formula where it will check a box if either one of these 2 scenarios happen 1) If the [Sales Admin CRM Removal Complete] date column is a date OR 2) If the [Reason for ITS] = "Obsolete Change…
-
the Right formula to make the date change every day
Hi, What is the way to make date change every day automatically and also I do not want the dates of previous operations to change, I just want to change dates for new processes, is there a formula for it? For example, in the Excel there is a option called enable iterative calculation, is there a similar option in…
-
RYG Status column, IF/AND/OR formula help
Hello Community, I'm trying to establish an RYG Status column formula in my sheet based on values in three other columns. One is a STATUS column with drop-down selections of Completed, Not Started, In Progress. The other two are date columns START DATE, FINISH DATE. Here's the statements without proper syntax: IF(STATUS)=…
-
RYGG Ball
Hello I have looked through the list of current Formula but cant find any that matches what I am trying to do (see below): If task due date is > 2 days from current date (today) AND Status is NOT STARTED or IN PROGRESS then flag the Green ball If a task due date is < 2 days from current date (today)AND Status is NOT…
-
Formula Help Part 2
Hi there, I would like to count all of the projects in my portfolio that are launching in Jan, in Feb, in March, etc. I have a Date column called Upcoming Launch Date. I posted previously and received this formula which works (January example): =COUNTIFS([Upcoming Launch Date:Upcoming Launch Date], IFERROR(MONTH(@cell), 0)…
-
Advice Needed to Optimize Workflow
Hello, I am looking to build a workflow for a review process in Smartsheets. There are multiple stages to this review process. For example, the item is submitted for Group A review. It must be approved by Group in order to be Submitted to Group B. What would be the best and most user friendly way to track who is reviewing…
-
Workday formula gives me #UNPARSEABLE
Hi. I'm trying to calculate a Deadline date based on varying lead time (calculated separately in another column). I have a confirmed lead time column (can very between 4 types) and a deadline calculation column (IA Date Calculation) using "IF" formula (if 8 weeks lead time = 5 business days, if 16 weeks = 10 business days,…
-
Need a conditional formula to automate status column based on values in date columns
Here's a screenshot of a very simple sheet I've set up where I've manually set the Status. I want to automate the value selection from the "Status" dropdown based on the presence of dates (Actuals) in my Start and End columns: * If the Start and End columns are blank, Status is "Not Started" * If Start has a date and End…
