leejoramo’s Profile

Community member since June 2018

points
83
Company
Mesa County Valley School Dist. 51

3

I am trying to chain Actions to automate an approval process.

I have column called "Process" that has the following Dropdown values:

  • School AD Review
  • School AD Approved
  • District AD Review
  • District AD Approved
  • District Finance Review
  • Approved
  • Denied

I want to use the changes in this the "Process"

3

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