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...
Thanks so much for the help @pressGO_design @Sho @TheTimeSavingCo I realized that the database is not as "clean" - some of the strings has an additional space in between, and so the calculation could not work. Possible to address this from the formul...
Thanks Adam!When creating the update record automation, what should be the record ID that i should be using?I have tried "Record ID", have also create unique project ID (project 1-7 will now have diff record ID), but none of these works but keep retu...
Hi Adam, thanks for responding!1. Table 1: 2 items are common across all (in yellow), in blues are sub-project specific info (only screenshot 1 of the 7 projects). 2. Convert each project into rows; automation is triggered based on number of markets...
Hi AdamHow exactly did you create the linked tables? Do you mind explaining it step by step?I am trying to create something similar but I am not getting there yet...
