-
Sheet Calculations are not copying
I have a complex sheet where users are entering data from a form and the sheet should be making a series of calculations. Each entry should be the next row (e.g. form enters to the next in in series) and then as the work is completed the process is updated on the sheet. It seems though each row is blank, the calculated…
-
If the column you are trying to delete is used in a formula then you see a message
If the row or column I am trying to delete is used in another sheet or referenced in a formula within the same sheet then I want to see a message pop up saying the same. This will prevent other sheets, reports, dashboards from getting messed up without me having to manually track all my references.
-
Merged: Include column description in Report
This discussion has been merged.
-
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…
