-
Start & Finish dates based on separate predecessors / or formula in duration
I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date.…
-
Vlookup
Hello, i have a sheet with billed claims including a column "Pending Amount", and "Detail ID", each line item has a different detail ID, now i want to update the pending amount column according to another sheet, i tried the simple Linking Cell method but it did not imported the pending amounts to the right detail ID's. and…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
-
Linking Sheets
I am working on a master SmartSheet to roll up other Sheets into one. When changes are made in the linked SmartSheets, this is not reflected in the master. If I add additional rows, my master is not updated What I am missing?
-
Linking Cells from a Vertical Orientation to a Horizontal Orientation
Hello everyone, I am creating a Project Pipeline which consists of many linked cells from many different individual project sheets. The individual project sheets are designed in a way that the information I am accessing is vertical. But in my pipeline, these same values need to be horizontally displayed. I need to link…
-
After Reducing Cross-Sheet References
Hello, I hit my maximum cross sheet reference of 25000 - I removed a SUBSTANTIAL amount of columns that were pulling useless information (we realized we didn't really as much information like we thought we did.) But - since removing a high quantity of cell links, my sheet is still not calculate the remaining…
-
Outgoing Links Not Working Since Update
Hello, I have been experiencing issues with my outgoing links not working since the last update. If I change the data in the outgoing link, it points to the correct cell, but the data is incorrect. The only way I can fix it is to delete the links and then add them again. I do not have the time to do this for all of my…
-
Contact List Cell-Linking?
Does anyone have a work around for cell-linking a contact list column that is used to calculate Resource Management and Conditional Formatting without creating another column? Issue - Person assigned to Task A needs to automatically be assigned to Task Z.
-
Lookup on a form?
Hi all, Is there a way to have a date/time field on a form look up data in a separate sheet to populate itself? I'm setting up a form for people to select a date and time slot to attend a training session. I thought about having the list in a separate sheet and then only show on the form dropdown the sessions that are…
-
Automatically repeat rows within a schedule (daily, weekly, monthly etc)
Hi, We use schedules to track publication output. Is there a way, when a form is completed or when a user adds to the schedule, an option can be selected to repeat the entry either daily, weekly, or monthly? Thanks, Dan