-
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…
-
If(And) #unpareseable error- help
Hi I am trying to write a formula to check values in two columns to set a flag on or off. If I write them independently without the AND function they work but when I write it with the AND I get a #unparseable Error. Here is the formula- =IF(And([Planned Finish]@row > TODAY(), [% Complete]@row > "100%") 0, 1). Any guidance…
-
Help on Countif formula
Hi I am trying to create a countif formula with multiple criteria . Heres what I am trying to do Countif Column1 = 1 and column 2 = N/A or Received at home I tried this formula but assume it is a check And for all 3 conditions as I get a value of 0 =COUNTIFS([Campus Id #]:[Campus Id #], =1, [ASA Not Given in ERSquad]:[ASA…
-
Parent/Child References
I am trying to use COUNTIF to refer to the number of projects that are under a certain parent row. I am having a hard time not coming up with a #INCORRECT ARGUMENT SET error.
-
Stuck on If Statements
Hi team, I'm building a dashboard and I need to show the current metric. I thought I'd show this by showing each month (for a chart) and using this formula to obtain the current: =IF(DEC3 = "", NOV3, IF(NOV3 = "", OCT3, IF(OCT3 = "", SEP3, IF(SEP3 = "", AUG3, IF(AUG3 = "", JUL3, IF(JUL3 = "", JUN3, IF(JUN3 = "", MAY3,…
-
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…
