-
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:…
-
Data Mesh
Hello, I'm using data mesh to bring information from other sheet(projects in this case) I have them linked with a column named "helper" I noticed that new data is not being added, however existing information is updated once a change is made in the source sheet. if I select copy and add data it adds duplicates at the end…
-
Outlook Integration - Attachment Handling Improvement
When I attach emails to different fields in my Smartsheet, I need to uncheck all the attachments that the system includes (i.e. all the graphics in an email signature that show up as individual attachments. Can you look into adding a "Select All" checkbox that will allow all attachments to be unchecked at once and only…
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
Workflow Automation Issue
Hello, Workflow automation pushed all projects not just those that were marked complete to completion sheet. Our entire schedule moved over. Why would this happen when the condition requires it to be marked Complete under the status column first?