-
Cell Linking
Is it possible to link a column to another sheet vs just a cell
-
Unique dropdown values in cells from linked sheets?
I want to create a unique dropdown menu based on a link from another sheet. On the linked sheet, one column will have a list of IDs and the second column will have a names that are associated with one type of ID. Each name has its own unique row, and IDs may appear multiple times for a group of names. The linkee(?) sheet…
-
Cell linking from one cell to a column on a different sheet?
Is there a formula that updates sheet 2's column when I enter data on sheet 1's row? ex) If a daily update starts on sheet 1 when the data is entered/attachment is attached, can a date automatically enter on sheet 2's date column? Sheet 2 is a running sheet so the date that I want automatically entered would be put once in…
-
Drop down list from another sheet
I currently have two sheets. Sheet1: Company List, Sheet2: Contacts. I am trying to create a dropdown column listing the companies from Sheet1 to populate the drop down for a column in Sheet2. This would essentially work as a lookup to keep the values in the contacts sheet limited to the known companies in sheet 1. I…
-
Auto populate date from helper sheet based on certain criteria
Hi All, Having a heck of a time with a helper sheet and formula. If I type in a date, ex: 1/31/2023, I would like another column to populate a date that is before that 1/31/2022 date The kicker is I need that date to be a specific day that I have listed on a helper sheet elsewhere (dates on the left "Board Meeting Dates")…
-
Anyone get Outbound Cell Links are Functioning but Not Displaying Properly?
What does this mean? Learn more just tells me about cell links, not why i'm getting this message every time I open a specific report.
-
Updating/Refreshing my file from a different website?
I have a file that I need to use updated fuel pricing at all times. The website my excel file is linked to updates once a week, usually on Tuesday. Need: How can I have this sheet refreshed from the website (EIA.gov) onto my Smartsheet file? Nice to have: I would like the data point I use on the sheet to be rounded to 2…
-
Month to Date and Year to Date spending
I have a sheet which contains date and amount spent, among other things. I want to show a MTD and a YTD metric on a dashboard. I am assuming I need to make a new sheet with a formula pulling data from the original sheet. I would like this to be ongoing as the original sheet is updated and then at the start of a new…
-
Is there a way to copy a single field to another sheet with Data Shuttle or in another manner?
I need to copy a Key field to various sheets at certain points in the processing. We keep having errors on the sheet [running out of space] when everything is on one sheet, so we are separating out based on processing criteria. We do not want all of the row to move, as this is where are trying to save fields and keep the…
-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…
