-
How to transform a Multi-select dropdown into multiple rows
Hello, I am using an intake form to capture the preferences of the submitter in a "Choices" column, there are over 100 available options in that column. I'd like to be able to group and sort these in a Report, however this is not possible to do with a Multi-Select Dropdown value. As such, I'd like to transform the…
-
Cannot create "Net Days" column formula
I have a column that auto-populates the number of days left between now and a project launch date. =NETDAYS(TODAY(), [Effective Date]@row) is the formula that I have in the column, and it works when applied row by row. It will not allow me to make it a column formula. Why not?
-
Enable File Handling in Bridge
Make it possible for Bridge to hand files as variables and results from actions. The example being a SharePoint API call returns a file that will then exist in the reference data of that complete action. This file/reference could then be used in future actions such as another API. My scenario required the use of the…
-
How to hide #DIVIDE BY ZERO error message
Hello, I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message. My current formula in the "Change" column is simple: =([Availability %]@row - [Previous Availability %]@row) / [Previous Availability %]@row But for any cells in the "Previous Availability %" column that have 0%, I get the #DIVIDE…
-
Removing commas if a field being joined is blank?
Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below: =JOIN([Pre-Bid…
-
Having Trouble with Approval Request Workflow being re-triggered by an automation
Hello! In the sheet we are using there is a box to check that will send out an approval request to someone. When the box is checked, it changes that approval column to "Submitted." And then that same column will change to "Approved" once they complete the approval request. The problem we are having is that the process will…
-
IF + INDEX COLLECT Formula
I am requesting help writing a formula. Currently I am using this formula: =INDEX(COLLECT({2023-24 Step 1: Self-Assessment Form Step1 Option}, {2023-24 Step 1: Self-Assessment Form District}, District@row, {2023-24 Step 1: Self-Assessment Form School2}, School@row), 1) I would like to update it so that based on a…
-
Project Metadata Sheet no updating
Hello I've completed the project intake form which has populated the Project Intake Sheet in the PMO Template set. I've then followed the instructions and copied the Project ID into the Project ID column in the Project Metadata sheet. When I do this, the rest of the data, e.g. Project Name, Project Manager etc is just…
-
Calculate planned % complete
Hello, I could not find this anywhere so hoping someone can help. I need to calculate the planned % complete based on the total duration of my project and elasped days. I want to exclude weekends and CDN and USA holidays. We do not track buydget so I am trying to get around calculating using the real earned value formulas.…
-
How do I change a date format in a formula to long date format?
Hello! I am setting up a meeting agenda in WorkApps and have a date column that displays the date in a long date format to avoid confusion between regions: Sep 28, 2020. I would like this date format to show in a formula. The pre-set formula is simply =[Next meeting]@row + " Meeting Agenda", so that looks like this:…