5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Dec 03, 2023
‎Mar 22, 2024

User Statistics

  • 9 Posts
  • 0 Solutions
  • 0 Kudos given
  • 1 Kudos received

User Activity

Hi AllI am looking for a formula to extract project status from a string with multiple response column. Criteria is IF "Market Single" is appear anywhere in the "Updated Status", then return as the 1st word in that particular string. Example below: t...
Hey I am stuck with the automation of "update records", and this is where I am:1. I have a table named "master project" (primary field) and in each row, consists of 7 sub-projects under the same master project. All 7 projects shared the same status o...
Hi AllI am trying to build a formula to reflect Master project status based on (sub)project status. Here's what I have. So the hierarchy should be:If ANY of the project status contains "ongoing", then master project status to reflect "ongoing"If "ong...
Dear AllI am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below: - If all of "project status" is "concluded", then "master project status" i...
Kudos from