-
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
-
Smartsheet as CRM with differentiated Accounts, Contacts, and Tasks
Hi everyone! I am trying to use Smartsheet as a simple but complete sales/CRM solution. I want to be able to have three different things: Accounts (like a company, "XYZ Tractors") Contacts (like a person, "John Smith, Senior Manager, employee at XYZ Tractors”) Tasks (“Create a sales quote for John”) In Smartsheet, there is…
