-
Old entries to the top?
Hi all, I just found out how to put new submissions appear on the top of the sheet, but I have old entries that I want it to be included to the top. I want these changes to apply to the old entries, how can I re-arrange these old entries? Thanks.
-
Tracking Created/ Modified and retaining historical data
Hello, I am managing a RAID log which was previously copied from Teams and past into Smartsheet. I'd like to track who and when: created a row modified a row I know those can be automated easily by system columns, however there are some historical data i the already existing columns (creator , created on & modifier,…
-
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…