I have a scenario where three people are providing an update on a project from different aspects, we have 3 fields for each person so the update requests prevent people from overwriting others update.…
I have sheet setup to capture our teams' weekly project updates, once per week I want it to email a report of the updates of active projects only (hence the report to filter on active projects). I set…
I have a list of products by t-shirt size, (S,M,L), i wanted the specific line items to be grouped and sorted by t-shirt size, but it only sorts them as L,M,S in alpha order. So i created a helper col…
I have a scenario where marketing managers update a sheet based on the activity they are doing. We then copy the row, via workflow, to another sheet which then triggers an update request for them to s…
I have a problem where I have two sheets, one with current information and one with historical data from 2021-2022. On both sheets, I have a concatenated field which is the unique id i am using to mat…
I have a workflow which triggers an email notification to users. In the body of the email I have two dates mentioned using the {{ }} to reference the date fields. Both date fields are formatted in the…
I am using datamesh to lookup a value in my target sheet and bring in some columns from my source sheet. Source Sheet, is a JIRA integration bringing in multiple rows for JIRA Tasks. Target Sheet, is …
I have two sheets, one which keeps track of dates and reminder dates which is maintained by team and looks like this: and another sheet which drives a form where people pick dates (a copy of the dates…
I have the above project plan setup The FOCUS AREA is a dropdown value. When i add children to a parent, i want the children to inherit the parents FOCUS AREA value. i created a helper column to ident…