-
Merged: Parent and Child Columns
This discussion has been merged.
-
Have You Developed a Quick Way to Find Columns Referenced in Automations?
I have a need to quickly go to an automation and modify it based upon some incorrect event happening in the sheet. My thought was to create a matrix, in a separate sheet, with automation names vertically in a column and then the column names horizontally in row 1 with an "X" in any column where that column name appears in…
-
Only Show Row if Data is in Specific Columns in a Report
Hello, We have project names, resources, and project managers all listed on the same row with the hours worked on particular days. I'd like to build a report, or a sheet that only shows rows if hours are listed past a certain point, meaning only show rows that have hours listed in the date columns. This will eliminate a…
-
Can i not add times in smartsheet?
HI - I am putting together meeting schedules (or at least trying to) as it would be helpful - then the calendar view would have the date AND time rather than just the title of the primary column. I looked at a Q&A from 2021 and they said to use the JOIN formula in the primary column. I don't really get this. I was hoping I…
-
Dynamic View Between 2 Departments with 1 source sheet
Hi! I was hoping someone might be able to assist me with a crazy idea and see if it's possible or if there would be a better option. Here it is: I'm wanting to create a single source sheet that would serve as the foundation of a data warehouse. It would have 2 dedicated admins who would act as bridges between both…
-
automation for moving specific columns
To move specific column values from my source sheet to another sheet, I can't use a lookup formula because the entries in the source sheet are constantly changing and not permanently established. In my second sheet, a new row should always be added with values from certain columns from the source sheet. The row should be…
-
Edit cells with column formula
Is there a way to edit the cells where a column formula is used? I am trying to link information from 1 database to another via a INDEX MATCH formula, so we don't have to re-write info 2 times. However, the databases does not contain the same projects (we link info based on project number). See below - Project name is…
-
Exclude blank fields from automation
Hello I set up an order form that contains all the items available to have their own column and as mandatory fields the user enters their name, email, managers name & email. This allows the user to complete 1 form only. They can order 1 item per category. Generally out of 10 products, staff only need 2 which means i have…
-
'Helper' Column Management via New Column Type (or Side Panel?)
Many of us, if not most, use one or more helper columns to achieve the Sheet functions that we need. Good practice is to hide the helper columns (when possible) so that the sheet user isn't bombarded with noise. Unfortunately, hidden columns still appear while in Card View. My solution for this is to move all of the helper…
-
Workaround to override column formula for dates?
Hi there, I have a sheet with 8,000 rows. In the sheet, each row has a task, task start date and task end date. When someone adds a start date to the first task, the rest of the dates are calculated with a formula, based on a lookup table that has values for how long each task takes. If I have 10 tasks, I want the formula…
