Hello! I have a "Client" drop-down box with 50 options. For simplicity's sake I'm just going to pretend these are values of 1 through 50. Many of the values in the drop-down are only relevant to certa…
Hello all! I have a sheet that is being used by people in the US and the UK. Users have requested that the date fields for their projects be formatted according to whichever region they're located in.…
Hello! I have a column in a sheet that is being populated with multiple pieces of information from Data Mesh. As shown in the example below, the cells in this column contain multiple dates. I would li…
Hello! I've created a calendar in the calendar app based on a single source sheet. When I go into the sharing settings of that calendar it gives me this message: Users with access to the source sheet …
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "…
Hello, I have a column named 2 Approval Package Current Projected Date. I am trying to return a text value based on that column compared to today's date. Here's what I'm looking for: If 2 Approval Pac…
Hello all! I have a sheet that contains a column titled Billing Date. This column is used to run revenue reports by month. I would like to add a column to my sheet with a checkbox that is only checked…
Hello all, I've run into an issue where one of my users added a filter called "Filter" to a sheet that has caused an issue. I'm looking for some help. When the filter is ON, the sheet has 900 rows ful…
Hello all. I have a sheet with numerous cost fields. When a user enters a new row, I would like these cost fields to be set to 0 if the user leaves them blank. For example, I have a column called Over…
Hello, I want to link a cell in one sheet to multiple cells in another sheet. The source cell contains a date, and I need that date to be linked to multiple cells (all in the same column) in another s…